The SQLServerFast Execution Plan Video Training – Block 2, advanced 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 advanced level of block 2: Reading data. Most performance issues are caused by operators reading too much data, or reading data in an inefficient way. In this block we build on the knowledge from the basic level to show how SQL Server deals with columnstore and memory-optimized data. We explain the internals of several specialized index types. We also cover reading data in parallelism or batch mode, plus some advanced optimizations. All of this will ensure that you can understanding everything the execution plans tells you about how data was accessed.

A total of five chapters, with a total viewing time of 2:56:27 (1:00:46 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).


View time: 4:17.

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

Chapter 1: Columnstore indexes

View time: 38:02 (7:26 demos).

Operators covered: Columnstore Index Scan, Key Lookup (for columnstore index).
Row-based vs column-based storage.
Storage structures of columnstore indexes.
Rowgroup, deltastore, deleted bitmap.
Segment elimination.

Chapter 2: Memory-optimized indexes

View time: 49:43 (12:25 demos).

Operators covered: Table Scan, Index Scan, Index Seek (for memory-optimized data).
Storage structures of memory-optimized data.
Varheap, Hash index, Bw-tree index.
In-memory columnstore indexes.
Natively compiled stored procedures.

Chapter 3: Special index types

View time: 24:50 (9:50 demos).

Filtered indexes: effect on storage structure.
XML indexes: internal structure and read strategies.
Spatial indexes: tessellation, internal structure, read strategies.
Full-text indexes: usage in execution plans.

Chapter 4: Reading data in parallel or batch mode

View time: 23:09 (9:32 demos).

Scans and ranges seeks in a parallel execution plan.

Parallel Page Supplier.
Batch mode execution plans.
Execution Mode Adapter.
Batch mode on rowstore.

Chapter 5: Assorted read optimizations

View time: 40:43 (21:33 demos).

Operators covered: Merge Interval.
Read-ahead reading.
Advanced scan aka merry-go-round scan.
Dynamic seek range.
Reading from partitioned tables and indexes.

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.