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.
-
-
Problem Queries in Table Partitioning (1 hour 30 minutes)
Learn how to identify and fix the top query patterns that can go wrong after you implement table partitioning.
-
Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes)
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.