SQL Server: Table Usage Query
Query to find table usage in SQL Server
Go to the control panel: Regional Settings: Click on the “Customize…” button on the region tab. Set time format to: h:mm:ss tt Set date format to: MM/dd/yyyy Date/Time Set the Time Zone Daylight savings (check […]
Count of records using a sub-query bypassing the limits of the Group By.