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 or Mastering Index Tuning, or log in if you already shelled out the cash.