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

Learn the pros and cons of using hints, trace flags, and scoped database configuration to tune your queries in SQL Server.
Learn the pros and cons of using hints, trace flags, and scoped database configuration to tune your queries in SQL Server.
Learn how to identify and fix the top query patterns that can go wrong after you implement table partitioning.
Learn how to set up a free blocking monitor, how to troubleshoot live blocking with free tools, how to configure built-in tools to document blocking when it happens, and how to trace deadlock graphs in SQL Server.