I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.
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.
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