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. Good news – I’ll teach you how in this 19-hour recorded class.
The class will take you longer to complete because it includes lab assignments that will take you hours to work through, and my students tell me they love doing these labs again and again. They're kinda like SQL Server video games! To follow along, you'll need to build your own SQL Server lab VM.
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
- 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)
- 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)
- 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)