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.
SQL SERVER – 3 Questions Answered on One Query Many Plans
Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.
One Query Many Plans – SQL in Sixty Seconds #171
After the blog post, lots of people asked me it will be more helpful if I can create a video on the same topic of one query many plans.
SQL SERVER – Same Result Same Query Plan – Different Entry in Cache
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.
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
SQL SERVER – Display Dates in Different cultures FORMAT
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.
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
Copy Database – SQL in Sixty Seconds #169
At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.
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.
9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168
This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.