Big One Time Use Queries
There is a newer version of this posting, click here. Part of my regular database maintenance or tuning routine is to look for the queries with cached plans that are taking up the most space, and have only been used …
There is a newer version of this posting, click here. Part of my regular database maintenance or tuning routine is to look for the queries with cached plans that are taking up the most space, and have only been used …
Teaching the Maintaining SQL Server 2005 class tonight. Week 5 – Working with TSQL, Transactions and Performance Tuning Here is the slide deck for the class tonight. DBA_Essentials_Class05_TSQL_TXN_and_Perf.pdf
The question came up as to which version of sql server is being run, and how do you determine the exact version number of the SQL server. Here is what I have come up with. From TSQL if you are …