Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.
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.
Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
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.
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.