- Meet the challenge code (9 minutes)
- Scripts and slide downloads
Let's Tune It
- Dig into the plan and test a nonclustered index (11 minutes)
- What can an indexed view do? (5 minutes)
- Bring in the nonclustered columnstore index! (8 minutes)
- Hacking in the Window Aggregate operator with a rowstore nonclustered index (9 minutes)
- Summary and recap (4 minutes)
- Quiz: check in on what you learned
- Course survey
SQLChallenges come out each month for registered students.
Check out the schedule and sign up for notifications here.