1.8 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. And then the followup after the index creations finish: In the above versions, I jump through lots of queries…

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.

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. And then the followup after the index creations finish: In the above versions, I jump through lots of queries...
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.
Menu