Avoid Join Hints – SQL in Sixty Seconds #172

I enjoy working on SQL Server Performance challenges and every day I learn something new. Recently one of the clients asked me  Comprehensive Database Performance Health Check if they can change the join hints to improve the performance of the query. Well, the reality is that I always Avoid Join Hints.

A very common thought is that SQL Server Optimizer needs human guidance and honestly, I believe it is not true. SQL Server optimizer has come a long way from its initial version and most of the time makes the right decision for the query. Let us watch a video today which gives you a practical example of Avoid Join Hints.

Here is the video where I describe why I like to Avoid Join Hints:

Here is the link to the blog post containing the script used in the video: SQL SERVER – Change Join Type for Query. Well, that’s it for today. If you liked this video, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Menu
Exit mobile version