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.
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
Last week, I had published 3 videos on CPU, Linux, and Shutdown. I received lots of good feedback on each of them and also got lots of questions.