This query asks, “How unsung am I?” Let’s tune it. (Remember, index starting points can be different depending on what indexes you’ve added while tuning Lab 6 overall.)
This query asks, “How unsung am I?” Let’s tune it. (Remember, index starting points can be different depending on what indexes you’ve added while tuning Lab 6 overall.)
To access this incredible, amazing content, you gotta get Live Class Season Pass, The Team Membership, Mastering Query Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class (59 min)
- 0.2 How to Set Up Your Own Lab Server
- 0.4 The BE CREEPY Method (14m)
- 1.1 How SQL Server Builds Query Plans (42m)
- 1.2 Cardinality Estimation (42m)
- 1.3 CTEs, Temp Tables, and APPLY (31m)
- 1.4 Lab 1: Improving Estimates (44m)
- 1.5 Using sp_BlitzCache to Find the Right (Wrong) Queries (43m)
- 1.6 Lab 2: Analyzing a Running Workload (63m)
- 2.1 Tuning for SELECT * and Lots of Rows (46m)
- 2.2 User-Defined Functions (34m)
- 2.3 Lab 3: Changing Results and Parameters (108m)
- 2.4 Dynamic SQL Pro Tips (43m)
- 2.5 Lab 4: Advanced Rewrites (72m)
- 3.1 Parameter Sniffing (85m)
- 3.2 Lab 5: Parameter Sniffing (90m)
- 3.3 Avoiding Deadlocks (31m)
- 3.4 SQL Server 2017 & 2019’s New Robots (13m)
- 4.1 Lab 6: The Final Setup (7m)
- 4.2 Lab 6: Index Tuning (33m)
- 4.3a Lab 6: usp_Q6627 (29m)
- 4.3b Lab 6: Logging sp_BlitzCache to a Table (5m)
- 4.3d Lab 6: usp_Report3 (15m)
- 4.3e Lab 6: usp_FindRelatedPosts (24m)
- 4.3f Lab 6: usp_Q6627, Take 2 (34m)