Forcing Parallelism SQLChallenge (48 minutes)
Can you coerce SQL Server into giving a query a parallel plan, without changing instance wide settings or re-writing the query?
-
-
Why Table Partitioning Does Not Speed Up Query Performance - With One Exception (52 minutes)
Learn why SQL Server's table partitioning feature won't make your queries against disk-based rowstore indexes faster-- and may even make them slower.
-
Auto Tuning with Automatic Plan Correction In Query Store (1 hour 8 minutes)
Learn to use this Query Store feature to identify and stabilize problem queries.
-
Defuse the Deadlock SQLChallenge (23 minutes)
Sharpen your skills at fighting blocking and index design by defusing this deadlock.
-
The Dirty Secrets of NOLOCK (50 minutes)
What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server? Learn the dirty secrets and potential uses of NOLOCK.
-
How Index Keys & Includes Work (1 hour)
Learn the internals of how disk based rowstore indexes work in SQL Server.