Links Discussed in Live Sessions of This Course

Links from Session 1

Forcing a Parallel Query Execution Plan by Paul White

  • Includes references on what can make a plan, or a zone in a plan, remain serial

Links from Session 2

Fixing a Filtered Index which is Causing Data Modifications to Fail by Kendra Little

Link to Microsoft’s reference: Required SET Options for Filtered Indexes

A plan explanation involving Lazy Spool by Hugo Kornelis

An explanation of Eager Spool by Fabiano Amorim

That’s Actually a Duplicate Index by Jason Strate

Latest publications by Louis Davidson on Relational Database Design

SQLChallenge focusing on tuning TSQL using windowing functions – Speed Up the Popular Names Query

Back to: Learn Indexing By Solving Problems (7 hours 23 minutes) > Links

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.