1.5 Adding Indexes with the DMVs
In the A part of the Method, let’s rely solely on Clippy’s recommendations during week 1, and then in weeks 2-4, we’ll start digging into the individual query plans. You’ll see why perfect is the enemy of good.
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
In the A part of the Method, let’s rely solely on Clippy’s recommendations during week 1, and then in weeks 2-4, we’ll start digging into the individual query plans. You’ll see why perfect is the enemy of good.
To access this incredible, amazing content, you gotta get 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
- 1.2 The D.E.A.T.H. Method: Dedupe and Eliminate
- 1.3 Why Index Read & Write Numbers Are Wrong
- 1.4 Lab 1 Setup: Dedupe and Eliminate
- 1.4b Lab 1: Dedupe and Eliminate – Brent Does It
- 1.6 Lab 2 Setup: Adding Indexes with Clippy and the DMVs
- 1.6b Lab 2: Adding Indexes with Clippy and the DMVs – Brent Does It
- 2.1 The D.E.A.T.H. Method: Tuning Indexes for Specific Queries
- 2.2 Tuning to Avoid Key Lookups and Residual Predicates
- 2.3 Lab 3 Setup: Tuning Indexes for Specific Queries
- 2.3b Lab 3: Tuning Indexes for Specific Queries – Brent Does It
- 2.4 The D.E.A.T.H. Method – Heaps and Clustered Indexes
- 2.5 Foreign Key and Check Constraints
- 2.6 Tuning Indexes to Avoid Blocking
- 2.7 Lab 4 Setup: Solving Blocking with Indexes
- 2.7b Lab 4: Solving Blocking with Indexes – Brent Does It
- 3.1 Filtered Indexes, Indexed Views, and Computed Columns
- 3.2 Indexing JSON for Faster Queries
- 3.3 Using the Second Column of an Index with Skip Scans
- 3.4 Lab 5 Setup: Leveraging Artisanal Indexes
- 3.4b Lab 5: Leveraging Artisanal Indexes – Brent Does It
- 4.1 Lab 6 Setup and Final Lessons
- 4.2 Lab 6: Doing the D.E.A.
- 4.3 Lab 6: Doing the D.E.A.T.
- About the Lab Exercises
- Bonus: Storytelling Time
- Bonus: Tips from the Index Sommelier