The SQLServerFast Execution Plan Video Training – Block 3, basic level

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 3: Combining data. When a query combines data from multiple sources, then there will be operators in the execution plan to combine the relevant data. Each operator has its own benefits, its own limitations, and its own performance characteristics. This level teaches you the basic algorithm of each, which will help you understand how they impact your query performance.

A total of six chapters, with a total viewing time of 3:45:10 (1:12:34 demos).
Sold for $24.95 per video, or $119.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).

Trailer

View time: 5:02.

A short overview of the contents of each chapter in this level, with fragments from each video.

Chapter 1: Logical join types

View time: 31:59 (6:20 demos).

Logical join types: Inner Join, Outer Join, Semi Join, Anti Semi Join, probed join.
Other ways to combine data: Concatenation, Union, Sequence, Switch.|
Unexpected join type transformations.

Chapter 2: Nested Loops

View time: 40:33 (14:39 demos).

Operators covered: Nested Loops.
Performance characteristics and risks of Nested Loops.
Detailed visualization of the Nested Loops algorithm.
Rebinds and rewinds.
Properties of the Nested Loops operator.
When is a scan better than a seek?
What is predicate pushdown?

Chapter 3: Merge Join

View time: 37:57 (17:03 demos).

Operators covered: Merge Join.
Performance characteristics of Merge Join.
The cost of sorting data, and how the optimizer gets around it.
Detailed visualization of the Merge Join algorithm.
Properties of the Merge Join operator.

Chapter 4: Hash Match

View time: 46:23 (13:01 demos).

Operators covered: Hash Match.
Performance characteristics and risks of Hash Match.
Hash functions and hash tables.
Memory Grant for a Hash Match.
Detailed visualization of the Hash Match algorithm.
Properties of the Hash Match operator.

Chapter 5: Adaptive Join

View time: 33:20 (6:18 demos).

Operators covered: Adaptive Join.
Performance comparison of Nested Loops, Hash Match, and Adaptive Join.
How and when Adaptive Join necessitates conversions between row mode and batch mode.
The algorithm for Adaptive Join.
Properties of the Adaptive Join operator.

Chapter 6: Other combining operators

View time: 34:58 (18:05 demos).

Operators covered: Concatenation, Sequence, Switch.
The algorithms for Concatenation, Sequence, and Switch.
Similarities and differences between these three operators.
Relevant properties for each of these operators.
Interleaved execution.

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