The SQLServerFast Execution Plan Video Training – Block 2, basic level NEW
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.
Most performance issues are caused by operators reading too much data, or reading data in an inefficient way. In this level, you will learn how most SQL Server data is organized on disk, and how scan, seek, and lookup operators traverse those storage structures to find the data you need, hopefully as efficient as possible. Understanding these basics will help you write more efficient queries and design more effective indexes.
This level consists of five chapters, with a total viewing time of 2:42:03 (58:14 demos).
Sold for € 19.95 or € 24.95 per video.
Bundle price: € 99.95 for the full level – that’s a € 14.80 discount!
(After purchasing one or more videos, you may have to leave the page and then reload it)
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
Trailer
View time: 3:55.
A short overview of the contents of each chapter in this level, with fragments from each video.
Chapter 1: Storage structures
View time: 27:48 (2:27 demos). Price: € 19.95.
Storage structures used for “standard” (rowstore on-disk) data.
Heap, clustered index, nonclustered index.
What are these structures, both conceptually and the internal details (B-tree, heap, IAM pages, index pages, etc)
Click here to view the video, or to purchase it if you don’t own it yet..
Chapter 2: Scan operators
View time: 40:58 (10:42 demos). Price: € 24.95.
Operators covered: Table Scan, Index Scan, Clustered Index Scan for “standard” data.
What happens “under the hood” in these operators?
Which properties to look at?
When is a scan better than a seek?
What is predicate pushdown?
Click here to view the video, or to purchase it if you don’t own it yet.
Chapter 3: Seek operators
View time: 32:41 (6:39 demos). Price: € 24.95.
Operators covered: Index Seek, Clustered Index Seek for “standard” data.
What happens “under the hood” in these operators? Which properties to look at?
Use case for seek operators.
Considerations for indexing strategy.
Click here to view the video, or to purchase it if you don’t own it yet.
Chapter 4: Lookup operators
View time: 36:11 (8:55 demos). Price: € 24.95.
Operators covered: Key Lookup, RID Lookup for “standard” data.
What happens “under the hood” in these operators? Which properties to look at?
Misleading row count estimate when predicate is pushed down.
Avoiding lookups: considerations for clustered index choice; considerations for covering indexes.
Click here to view the video, or to purchase it if you don’t own it yet.
Chapter 5: Special scans
View time: 29:26 (14:05 demos). Price: € 19.95.
Operators covered: Constant Scan, Deleted Scan, Inserted Scan.
What happens “under the hood” in these operators? Which properties to look at?
Constant Scan: How to understand its role when used in non-obvious ways.
Deleted Scan, Inserted Scan: Where do these get their data from?
Click here to view the video, or to purchase it if you don’t own it yet.