-
Module 2: Execution plans
14 Lessons-
StartModule introduction
-
StartQuery compilation
-
StartEstimated execution plans
-
StartActual execution plans
-
StartExecution plan formats
-
StartSaving execution plans
-
StartCapture plans using SQL Trace or Profiler
-
StartCapture plans using Extended Events
-
StartCapture plans using DMVs
-
StartReusing execution plans
-
StartPlan-affecting SET options
-
StartExecution plans quiz
-
StartExecution plans lab
-
StartExecution plans lab solution
-
-
Module 3: Reading execution plans
10 Lessons -
Module 4: Basic operators
17 Lessons-
StartModule introduction
-
StartSelect
-
StartConstant scan
-
StartCompute scalar
-
StartTable scan
-
StartClustered index scan
-
StartColumnstore index scan
-
StartClustered index seek
-
StartIndex scan
-
StartIndex seek
-
StartTop
-
StartSort
-
StartConcatenation
-
Start
-
StartBasic operators quiz
-
StartBasic operators lab
-
StartBasic operators lab solution
-
-
Module 10: Spools and parallelism
12 Lessons -
Module 12: Advanced concepts
14 Lessons-
StartModule introduction
-
StartCompare plans
-
StartLive execution plans
-
StartTable hints
-
StartJoin hints
-
StartGroup and union hints
-
StartCompilation hints
-
StartPlan reuse hints
-
StartQuery store
-
StartPlan guides
-
StartForcing plans with query store
-
StartAdvanced concepts quiz
-
StartAdvanced concepts lab
-
StartAdvanced concepts lab solution
-
