The best way to fix bad performance of SQL Server queries is to look at their execution plans. The SQLServerFast Execution Plan Video Training helps you read and understand those execution plans. For more information about this video course, click here.
This is the basic level of block 6: Sorting and grouping. In these videos, you will learn the basics of grouping and aggregating, and sorting the data. You will also learn what segmenting is and what its benefits are, and you will gain insight in how the Window Spool operator evaluates aggregations with a window frame (OVER clause with ORDER BY).
A total of five chapters, with a total viewing time of 2:42:12 (1:11:34 demos).
Sold for $24.95 per video, or $99.95 if you purchase the whole level at once.
The videos below will play the applicable video if you are logged in to Vimeo and if you have previously purchased access to that video, or to the whole level. If not, they will play the trailer instead. The “Buy” button allows you to log in and purchase the video. Or you can use the “Buy all” link, on the trailer, or on the left hand side of the popup, to benefit from the discounted price for buying the whole level at once.
(Note: If you are logged in to Vimeo and still see the trailer instead of the video, click the “buy” or “buy all” button. That should refresh the settings and show the video).
I have received reports of customers who were unable to purchase these videos. They were presented with a message “This video is not for your region”. This is not correct, there are no regional restrictions on these videos. I have raised a ticket with Vimeo on November 8, 2025. So far, they have not resolved the issue. If you run into this issue, then please reach out to me, so we can try to find a workaround.
See https://sqlserverfast.com/video for more information.
To download the slides, go to https://sqlserverfast.com/slides
To download the demo code, go to https://sqlserverfast.com/democode