The question I was asked was about a query that had the same result same query plan but the different entry in the cache, is that possible.
SQL SERVER – Replace Rowstore Clustered Index with Columnstore Clustered Index
Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
Video Resources for 9 SQL SERVER Performance Tuning Tips
I had blogged about 9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168. The video got an amazing response and lots of comments.
SQL SERVER – 3 Queries to Detect Memory Issues
One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
SQL SERVER – Map SQL Server Session ID to OS Thread ID
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.Â
SQL SERVER – Parallelism and Threads with No Work
One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
SQL SERVER – Top 1 and Index Scan
Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.