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!
Scripts
https://github.com/LitKnd/SQLWorkbooks/tree/main/query_tuning_hints_optimizer_hotfixes
Each video has closed captions in English. A written transcript is included with each lesson.