Watch me do Lab 2 using sp_BlitzCache to find our most resource-intensive query plans, hand-design indexes for them one at a time, and then merge the indexes together to stay within the 5 & 5 rule.
1.7 Lab 2: Tuning Indexes for Specific Queries – Brent Does It
Watch me do Lab 2 using sp_BlitzCache to find our most resource-intensive query plans, hand-design indexes for them one at a time, and then merge the indexes together to stay within the 5 & 5 rule.
To access this incredible, amazing content, you gotta get Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class (~4 hours)
- 0.2 Download the Slides and Scripts
- 1.2 The D.E.A.T.H. Method: Dedupe and Eliminate
- 1.3 D.E. Tools and Their Weaknesses
- 1.4 Lab 1 Setup: Dedupe and Eliminate
- 1.4b Lab 1: Dedupe and Eliminate – Brent Does It
- 1.5 The D.E.A.T.H. Method: Tuning Indexes for Specific Queries
- 1.6 Lab 2 Setup: Tuning Indexes for Specific Queries
- 2.1 Adding Indexes with the DMVs
- 2.2 Tuning to Avoid Key Lookups and Residual Predicates
- 2.3 Lab 3 Setup: Adding Indexes with Clippy and the DMVs
- 2.3b Lab 3: Adding Indexes with Clippy and the DMVs – Brent Does It
- 2.4 Tuning Indexes to Avoid Blocking
- 2.5 Lab 4 Setup: Solving Blocking with Indexes
- 2.6 Lab 4: Solving Blocking with Indexes – Brent Does It
- 3.1 The D.E.A.T.H. Method – Heaps and Clustered Indexes
- 3.2 Filtered Indexes, Indexed Views, and Computed Columns
- 3.3 Lab 5 Setup: Leveraging Artisanal Indexes
- 3.3b Lab 5: Leveraging Artisanal Indexes – Brent Does It
- 3.4 Foreign Key and Check Constraints
- 3.5 Tips from the Index Sommelier
- 3.6 Lab 6 Setup and Final Lessons
- 3.7 Lab 6: Doing the D.E.A.
- 3.8 Lab 6: Tuning Indexes for Specific Queries
- About the Lab Exercises
- Bonus: Storytelling Time