The SQLServerFast Execution Plan Video Training – downloads
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.
Downloads
In the table below, you will find links to download the slide decks and demo code used in the videos.
The slide decks can be used to review things at your leisure, or to get an idea of the content of a level before deciding whether or not to purchase access to it. You can also print them, so you can take notes while watching the videos. Please be environmental aware: only print what you need, print double-sided, and consider scaling down before printing.
The demo code can be used to replay the demos, look at things I don’t show, and as a starting point for further experimentation. Most of the 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 and level | Slide decks | Demo scripts |
| Block 1: Understanding Execution Plans – basic level | Download | Download |
| Block 1: Understanding Execution Plans – advanced level | Download | Download |
| Block 2: Reading data – basic level | Download | Download |
| Block 2: Reading data – advanced level | Download | Download |
| Block 3: Combining data – basic level | Download | Download |
| Block 3: Combining data – advanced level | Download | Download |
| Block 4: Sorting and grouping – basic level | Not yet available | Not yet available |
| Block 4: Sorting and grouping – advanced level | Not yet available | Not yet available |
| Block 5: Various data manipulations – basic level | Not yet available | Not yet available |
| Block 5: Various data manipulations – advanced level | Not yet available | Not yet available |
| Block 6: Technical operators – basic level | Not yet available | Not yet available |
| Block 6: Technical operators – advanced level | Not yet available | Not yet available |
| Block 7: Data modifications – basic level | Not yet available | Not yet available |
| Block 7: Data modifications – advanced level | Not yet available | Not yet available |
Slide decks and demo scripts for a level will always release before or when that level is released.