Autoplay
Autocomplete
Previous Lecture
Complete and continue
Mastering Query Tuning
Before the Class
Prerequisites
Introductions and Overview (10:42)
Download the Slide Decks
Change Log for This Class
The Architect and the Builder: Estimating & Executing Plans
How SQL Server Builds Query Plans (27:29)
When the Architect Gets an Early Estimate Wrong (27:24)
When the Architect Gets a Late Estimate Wrong (25:39)
Lab 1 Setup: Improving Estimates (4:09)
Lab 1: Brent's Solution (85:02)
How SQL Server 2017, 2019, and 2022 Try to Fix Queries Automatically
The Tuning Robots in SQL Server 2017, 2019, and 2022 (51:27)
Refresher: Using sp_BlitzCache for Query Tuning (32:51)
T-SQL Tuning Speed Hacks (19:07)
Lab 2 Setup: Use sp_BlitzCache on a Running Workload (7:27)
Lab 2: Brent's Solution (38:20)
Rewrites: Changing Parameters, Results, and Refactoring
Tuning for SELECT * and Lots of Rows (45:05)
Why User-Defined Functions Suck, and How to Fix 'Em (22:25)
Lab 3 Setup: Rewrites & Refactors (6:39)
Lab 3: Brent's Solution for mqt_36660 and mqt_Lab3_Level1 (52:19)
Lab 3: Brent's Solution for usp_ActivityByLocation (53:17)
Lab 3: Brent's Solution for usp_TopQuestionersByTag (57:40)
Dynamic SQL
Fixing Multi-Parameter Queries with Dynamic SQL (46:39)
Lab 4 Setup: Rewrites & Dynamic SQL (2:27)
Lab 4: Brent's Solution for mqt_Lab4_Level1 aka usp_UsersByAcceptedAnswerPercentageRate (41:54)
Lab 4: Brent's Solution for usp_FindRecentInterestingPostsForUser (20:15)
Lab 4: Brent's Solution for usp_Q59985 (119:42)
Advanced Rewrites to Fix Scalability Problems
How Parallelism Balances Work Across Threads (39:56)
Fixing Unbalanced Parallelism: A Live Surprise (29:02)
Avoiding Deadlocks by Modifying T-SQL (29:09)
Using Batches to Do a Lot of Work Without Blocking (25:38)
Recap and Final Lab
Lab 5 Setup and Class Recap (4:56)
Round 1: Index Tuning with the D.E.A.T.H. Method (20:21)
Working on usp_Q1080 (29:53)
Working on usp_Q6627 (28:27)
Working on usp_Q8116 (20:51)
Working on usp_Report3 (19:03)
Intermission: Reading sp_BlitzCache History (4:47)
Working on usp_Q7521 (25:05)
Working on usp_FindRelatedPosts (22:40)
Working on usp_Q6627 for More Improvements (34:02)
Bonuses
The Ascending Key Problem (46:39)
The Tuning Robots in SQL Server 2017, 2019, and 2022
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock