Query Tuning with Hints & Optimizer Hotfixes (2 hours 15 minutes)

In this course you’ll learn the pros and cons of using hints, trace flags, and scoped database configuration to tune your queries in SQL Server.

Try the course quizzes anytime: using hints, recompile, optimizer hotfixes

Demos are run against SQL Server 2016, but most of the hints and settings shown can be used against lower or higher versions of SQL Server, too!



Each video has closed captions in English. A written transcript is included with each lesson.