The required was very unique and we were able to solve the problem with the help of READPAST query hint. Comprehensive Database Performance Health Check
SQL SERVER – Removing Extra TempDB Files
The other day I ended up a very interesting situation while working with Comprehensive Database Performance Health Check, with TempDB files.
SQL SERVER – How to Shrink tempDB Database?
In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.
SQL SERVER – Dynamic SQL and Temporary Tables
Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.
SQL SERVER – Dynamic SQL and Global Temporary Tables
During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution
Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.
SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure
SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.