SQL Server Execution Plans for Developers and DBAs

Zenler Player

Your course is loading. Hang tight.

Who is this course for ? Preview
Who is Greg ? Preview
What will I learn in this course ? Preview
Configuring your lab environment
Configuring demo scripts and additional databases (optional)

Module introduction
Why execution plans matter
SQL Server execution engines
Relational engine - parser
Relational engine - algebrizer
Relational engine - optimizer
Query cost
Core concepts quiz

Module introduction
Query compilation
Estimated execution plans
Actual execution plans
Execution plan formats
Saving execution plans
Capture plans using SQL Trace or Profiler
Capture plans using Extended Events
Capture plans using DMVs
Reusing execution plans
Plan-affecting SET options
Execution plans quiz
Execution plans lab
Execution plans lab solution

Module introduction
Operator types
Blocking operators
Node IDs and data flow
Data volumes
Operator cost
Operator properties
Reading execution plans quiz
Reading execution plans lab
Reading execution plans lab solution

Module introduction
Select
Constant scan
Compute scalar
Table scan
Clustered index scan
Columnstore index scan
Clustered index seek
Index scan
Index seek
Top
Sort
Concatenation
Print
Basic operators quiz
Basic operators lab
Basic operators lab solution

Module introduction
Why lookups occur
RID lookup
Key lookup
Covering indexes
Lookups quiz
Lookups lab
Lookups lab solution

Module introduction
Join strategy vs join type
SQL Server join types
Nested loop
Hash match
Merge join
Adaptive join
Bitmap filters
Joins quiz
Joins lab
Joins lab solution

Module introduction
Aggregations
Hash match
Stream
Filter
Aggregations quiz
Aggregations lab
Aggregations lab solution

Module introduction
Insert
Update
Delete
Merge
Assert
Data modification quiz
Data modification lab
Data modification lab solution

Module introduction
Types of views
Standard views
Indexed views
Views quiz
Views lab
Views lab solution

Module introduction
Spools
Eager spools
Lazy spools
Table spools
Index spools
Row count spools
Window spools
Parallel queries
Spools and parallelism quiz
Spools and parallelism lab
Spools and parallelism lab solution

Module introduction
Cursor declarations
Forward-only read-only cursors
Static cursors
Keyset cursors
Dynamic cursors
Open cursor and fetch
Conditionals
Close and deallocate
Cursors quiz

Module introduction
Compare plans
Live execution plans
Table hints
Join hints
Group and union hints
Compilation hints
Plan reuse hints
Query store
Plan guides
Forcing plans with query store
Advanced concepts quiz
Advanced concepts lab
Advanced concepts lab solution

Summary and further steps