Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Mastering Query Tuning
Before the Class
Prerequisites
Introductions and Overview (9:54)
Download the Slide Decks
The Architect and the Builder: Estimating & Executing Plans
How SQL Server Builds Query Plans (36:54)
When the Architect Gets an Early Estimate Wrong (35:00)
When the Architect Gets a Late Estimate Wrong (26:20)
Lab 1 Setup: Improving Estimates (3:52)
Lab 1: Brent's Solution (37:03)
How SQL Server 2017 and 2019 Try to Fix Queries Automatically
SQL Server 2017 & 2019's New Self-Tuning Robots (41:15)
Refresher: Using sp_BlitzCache for Query Tuning (32:51)
Lab 2 Setup: Use sp_BlitzCache on a Running Workload (4:09)
Lab 2: Brent's Solution (39:00)
Rewrites: Changing Parameters, Results, and Refactoring
Tuning for SELECT * and Lots of Rows (46:32)
Why User-Defined Functions Suck, and How to Fix 'Em (31:38)
Lab 3 Setup: Rewrites & Refactors (7:52)
Lab 3: Brent's Solution for mqt_Lab3_Level1 (42:37)
Lab 3: Brent's Solution for usp_MQT36660 (31:43)
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 (35:14)
Lab 4 Setup: Rewrites & Dynamic SQL (3:03)
Lab 4: Brent's Solution for mqt_Lab4_Level aka usp_UsersByAcceptedAnswerPercentageRate (39:33)
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 (37:45)
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 (23:19)
Recap and Final Lab
Lab 5 Setup and Class Recap (5:14)
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)
Working on usp_Q8116
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock