Question: If they can change the join hints to improve the performance of the query. Well, the reality is that I always Avoid Join Hints.
SQL SERVER – Table Variables, Temp Tables and Parallel Queries
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.