The SQLServerFast Execution Plan Video Training is an extensive set of videos to help SQL Server professionals how to read and understand execution plans, and how they can help understand and fix bad performance. See here for more details.

Demo code download

In the table below, you will find links to download the demo code used in the videos. I encourage viewers to experiment with this code in their own environment!

Most of these demos use one or more of the standard sample databases created and distributed by Microsoft: AdventureWorks (download here) and ContosoRetailDW (download here). I might occasionally use other databases; this will be indicated in the demo script.

 

Block name	Demo scripts
Block 1: Understanding Execution Plans – basic level	Download
Block 1: Understanding Execution Plans – advanced level	Download
Block 2: Reading data – basic level	Download
Block 2: Reading data – advanced level	Not yet available
Block 3: Combining data – basic level	Not yet available
Block 3: Combining data – advanced level	Not yet available
Block 4: Sorting and grouping – basic level	Not yet available
Block 4: Sorting and grouping – advanced level	Not yet available
Block 5: Various data manipulations – basic level	Not yet available
Block 5: Various data manipulations – advanced level	Not yet available
Block 6: Technical operators – basic level	Not yet available
Block 6: Technical operators – advanced level	Not yet available
Block 7: Data modifications – basic level	Not yet available
Block 7: Data modifications – advanced level	Not yet available

 

Demo scripts will always release before or when a new block is released.