Tag Info

New answers tagged


For a database in SQL Server, there's a setting called Auto-Close, which is meant to minimize the amount of resources used while SQL Server is running, but no users are actively doing things. This setting is enabled by default in Express Edition instances, as those are usually running on developer workstations where performance isn't critical, and resources ...


It's not free but SqlSmash is also an addin for SSMS 2012, 2014. Disclaimer: I am the developer for the product


Hitting F4 also enables properties view, which shows the start time, finish time, and run time. Also, if you Include Client Statistics (under Query menu), you can get a history of when you ran the query, along with various statistics such as run time and number of rows.

Top 50 recent answers are included