SQL Server - Query Plan Analysis

Files Included :
FileName :01 Course Introduction.wmv | Size: (1.52 MB)
FileName :02 Why Do We Care About QPs.wmv | Size: (1.55 MB)
FileName :03 What Doesn't a Query Plan Tell Us.wmv | Size: (1.54 MB)
FileName :04 Course Structure.wmv | Size: (791.83 KB)
FileName :01 Module Introduction.wmv | Size: (897.44 KB)
FileName :02 Capturing a Plan.wmv | Size: (2.06 MB)
FileName :03 Demo - Capturing a Plan.wmv | Size: (21.57 MB)
FileName :04 Why Deprecate.wmv | Size: (1.2 MB)
FileName :05 DMOs.wmv | Size: (1.62 MB)
FileName :06 Demo - DMOs.wmv | Size: (6.53 MB)
FileName :07 SQL Trace and Extended Events.wmv | Size: (915.05 KB)
FileName :08 Demo - Using Extended Events to Capture Execution Plans.wmv | Size: (8.53 MB)
FileName :09 Graphical Showplan.wmv | Size: (1.58 MB)
FileName :10 Demo - Graphical Showplan.wmv | Size: (17.69 MB)
FileName :11 SQL Sentry Plan Explorer.wmv | Size: (956.15 KB)
FileName :12 Demo - SQL Sentry Plan Explorer.wmv | Size: (7.33 MB)
FileName :13 Estimated vs Actual.wmv | Size: (1.97 MB)
FileName :14 Demo - Estimated vs Actual.wmv | Size: (17.27 MB)
FileName :01 Module Introduction.wmv | Size: (1.07 MB)
FileName :02 Iterators - Operators.wmv | Size: (1.47 MB)
FileName :03 Query Tree.wmv | Size: (1.02 MB)
FileName :04 Operator Cost (1).wmv | Size: (897.45 KB)
FileName :05 Operator Cost (2).wmv | Size: (827.03 KB)
FileName :06 Demo - Operator Cost.wmv | Size: (20.34 MB)
FileName :07 Operator Memory (1).wmv | Size: (1.06 MB)
FileName :08 Operator Memory (2).wmv | Size: (1.54 MB)
FileName :09 Demo - Operator Memory.wmv | Size: (12.58 MB)
FileName :01 Module Introduction.wmv | Size: (1.27 MB)
FileName :02 Table and Index Scans.wmv | Size: (1.53 MB)
FileName :03 Demo - Table and Index Scans.wmv | Size: (4.34 MB)
FileName :04 Index Seeks.wmv | Size: (671.51 KB)
FileName :05 Demo - Index Seeks.wmv | Size: (8.33 MB)
FileName :06 Lookups.wmv | Size: (1.62 MB)
FileName :07 Demo - Lookups.wmv | Size: (7.34 MB)
FileName :08 Join Considerations.wmv | Size: (1.87 MB)
FileName :09 Outer - Inner Terminology.wmv | Size: (2.35 MB)
FileName :10 Demo - Outer-Inner Terminology.wmv | Size: (2.29 MB)
FileName :11 Nested Loop.wmv | Size: (1.14 MB)
FileName :12 Demo - Nested Loop.wmv | Size: (12.32 MB)
FileName :13 Merge Join.wmv | Size: (1.2 MB)
FileName :14 Demo - Merge Join.wmv | Size: (3.95 MB)
FileName :15 Hash Match Join.wmv | Size: (1.42 MB)
FileName :16 Demo - Hash Match Join.wmv | Size: (15.1 MB)
FileName :17 Filter.wmv | Size: (1.22 MB)
FileName :18 Demo - Filter.wmv | Size: (9.65 MB)
FileName :19 Stream Aggregate.wmv | Size: (1000.16 KB)
FileName :20 Demo - Stream Aggregate.wmv | Size: (4.56 MB)
FileName :21 Hash Match (Aggregate).wmv | Size: (1008.95 KB)
FileName :22 Demo - Hash Match Aggregate.wmv | Size: (4.56 MB)
FileName :23 Sort.wmv | Size: (997 B)
FileName :24 Demo - Sort.wmv | Size: (8.03 MB)
FileName :25 Spools.wmv | Size: (1.31 MB)
FileName :26 Eager Spool and 'Halloween Protection'.wmv | Size: (2.13 MB)
FileName :27 Demo - Eager Spool.wmv | Size: (4.14 MB)
FileName :28 Constant Scan.wmv | Size: (832.89 KB)
FileName :29 Demo - Constant Scan.wmv | Size: (5.31 MB)
FileName :30 Assert.wmv | Size: (401.56 KB)
FileName :31 Demo - Assert.wmv | Size: (6.43 MB)
FileName :32 Compute Scalar.wmv | Size: (1.02 MB)
FileName :33 Demo - Compute Scalar.wmv | Size: (3.16 MB)
FileName :34 Identifying Parallelism in the Plan.wmv | Size: (712.58 KB)
FileName :35 Exchange Operators.wmv | Size: (1.02 MB)
FileName :36 Demo - Exchange Operators.wmv | Size: (5.48 MB)
FileName :37 Bitmap.wmv | Size: (521.85 KB)
FileName :38 Demo - Bitmap.wmv | Size: (4.34 MB)
FileName :39 Merge Interval.wmv | Size: (425.03 KB)
FileName :40 Demo - Merge Interval.wmv | Size: (6.36 MB)
FileName :41 Concatenation.wmv | Size: (263.64 KB)
FileName :42 Demo - Concatenation.wmv | Size: (4.49 MB)
FileName :43 Segment and Sequence Project.wmv | Size: (759.53 KB)
FileName :44 Demo - Segment and Sequence Project.wmv | Size: (7.1 MB)
FileName :01 Module Introduction.wmv | Size: (1.11 MB)
FileName :02 The 'Basics'.wmv | Size: (1.68 MB)
FileName :03 Demo - Missing index warnings.wmv | Size: (6.38 MB)
FileName :04 Lookups.wmv | Size: (1.05 MB)
FileName :05 Nested Loop Patterns.wmv | Size: (1.62 MB)
FileName :06 Merge Join Patterns.wmv | Size: (1.05 MB)
FileName :07 Demo - Merge Join Overhead.wmv | Size: (8.04 MB)
FileName :08 Hash Join Patterns.wmv | Size: (1.19 MB)
FileName :09 Demo - Hash Join Spills.wmv | Size: (11.71 MB)
FileName :10 Stop-and-Go Operators.wmv | Size: (824.09 KB)
FileName :11 Sort Patterns.wmv | Size: (1.28 MB)
FileName :12 Aggregates.wmv | Size: (973.75 KB)
FileName :13 Predicates.wmv | Size: (753.67 KB)
FileName :14 Spool Overhead.wmv | Size: (1.07 MB)
FileName :15 Parallelism Performance Aspects.wmv | Size: (777.15 KB)
FileName :16 Data Modification Plan Patterns.wmv | Size: (712.58 KB)
FileName :17 Demo - Data Modification Plan Patterns.wmv | Size: (8.88 MB)
FileName :18 Cardinality Estimate Issues.wmv | Size: (706.71 KB)
FileName :19 Data Type Conversions.wmv | Size: (1.21 MB)
FileName :20 PlanAffectingConvert.wmv | Size: (486.64 KB)
FileName :21 Demo - PlanAffectingConvert.wmv | Size: (12.73 MB)
FileName :22 NoJoinPredicateWarning.wmv | Size: (765.4 KB)
FileName :23 ColumnsWithNoStatistics Warning.wmv | Size: (1.03 MB)
FileName :24 Parameter Sniffing.wmv | Size: (1.48 MB)
FileName :25 Demo - Parameter Sniffing.wmv | Size: (14.51 MB)
FileName :26 Columnstore Index Execution Mode.wmv | Size: (1.23 MB)
FileName :27 Course Summary.wmv | Size: (1.43 MB)]
Screenshot
[Image: W7Rdibl9_o.jpg]