The SQLServerFast Execution Plan Video Training – Block 1, advanced level TEST 2

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 advanced level of block 1: Understanding execution plans. In these videos you will learn what many commonly used properties mean; how order of rows impacts execution plans; some internals of the optimization processes and how this affects the execution plan; and what batch mode is and how it affects performance.

This level consists of five chapters, with a total viewing time of 2:42:03 (58:14 demos).
Sold for € 19.95 / € 24.95 per video; or € 89.95 (a € 19.80 discount) to purchase the whole level at once.

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

Chapter 1: Properties of the plan

View time: 29:39 (3:24 demos). Price: € 19.95.

Properties on top left operator are actually about the plan as a whole.
All relevant properties are explained here.

Click here to view.

Chapter 2: Common operator properties

View time: 39:08 (23:40 demos). Price: € 24.95.

Properties that appear on many operators with the same meaning everywhere.
Generic guidelines on how to read execution plans, trace data, and understand issues.

Click here to view.

Chapter 3: Order of data in the data stream

View time: 28:09 (9:10 demos). Price: € 19.95.

When is order of data in the data stream relevant and when not?
How do operators affect the order of data in the data stream?
How do ordering considerations impact execution plans?

Click here to view.

Chapter 4: Missing nodes

View time: 24:13 (11:53 demos). Price: € 19.95.

Phases in the optimization process.
Effect of post optimization cleanup phase on Node ID property in execution plans.
Confusing effect of post optimization cleanup on other properties.

Click here to view.

Chapter 5: Batch mode versus row mode

View time: 40:54 (10:07 demos). Price: € 24.95.

What is row mode, what is batch mode, how do they differ?
Internals of batch mode.
Details of batch mode support in various versions of SQL Server.

Click here to view.