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. In the above version, I jump through queries quickly. If you’d rather see me dig exhaustively through a single…

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. In the above version, I jump through queries quickly. If you’d rather see me dig exhaustively through a single...
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.