The SQLServerFast Execution Plan Video Training

The SQLServerFast Execution Plan Video Training is an extensive set of videos, at this time not complete yet, to help SQL Server professionals learn and understand all they’ll ever need to know to read and understand execution plans; and to use this tool to identify causes of bad performance, and find ways to improve performance. See this page for pricing and availability, and this page for full 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 Not yet available
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 be released before or when a new block is released.

Menu

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close