What you will get:
- Watch on any Device
- 7 sections
- lectures
- of video
Last updated: 31 Aug 2022
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
Course Description
You need to speed up an existing app, and you’re allowed to change both queries & indexes, but you can’t throw hardware at it. Let’s tackle it in 3 days of labs in this recorded class. (This is not a live class - if you want to attend live, check out my Live Class Season Pass.)
Want to save a bundle? This class is included in my Recorded Class Season Pass: Mastering bundle.
Course Curriculum
Before the Class
Available in
days
days
after you enroll
The Architect and the Builder: Estimating & Executing Plans
Available in
days
days
after you enroll
How SQL Server 2017, 2019, and 2022 Try to Fix Queries Automatically
Available in
days
days
after you enroll
Rewrites: Changing Parameters, Results, and Refactoring
Available in
days
days
after you enroll
- 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 (8:16)
- 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
Available in
days
days
after you enroll
- Fixing Multi-Parameter Queries with Dynamic SQL (46:39)
- Lab 4 Setup: Rewrites & Dynamic SQL (2:25)
- 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
Available in
days
days
after you enroll
Recap and Final Lab
Available in
days
days
after you enroll
- Lab 5 Setup and Class Recap (4:08)
- 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)