Mastering the Basics of SQL Server Query Optimization

2016
1:09 hours

├── 01 Introduction – How the Query Optimizer Works
│ ├── 001 An Introduction to This Course.mp4
│ ├── 002 Is This Course Right for You.mp3
│ ├── 003 Course Downloads.html
│ ├── 004 The SQL Engine.mp4
│ ├── 005 The Query Processing Process.mp4
│ ├── 006 The Search Space.mp4
│ ├── 007 Whats In the Cost.mp4
│ ├── 008 Plan Cache Reuse.mp4
│ ├── 009 What Causes Recompilation.mp4
│ ├── 010 Terminology.mp4
│ ├── 011 Summary.html
│ └── 012 Quiz Quiz.html
├── 02 Execution Plans
│ ├── 001 Brain Overload Warning.html
│ ├── 002 Anatomy of Execution Plan.mp4
│ ├── 003 The Iterator.html
│ ├── 004 Execution Plan Output Options.mp4
│ ├── 005 Scan VS Seek.mp4
│ ├── 006 Scanning Demos.mp4
│ ├── 007 Seeking Demos.mp4
│ ├── 008 The Bookmark Lookup.mp4
│ ├── 009 Aggregations.mp4
│ ├── 010 Hash Match Operator.mp4
│ ├── 011 Joins – The Nested Loop.mp4
│ ├── 012 Join – The Merge Join.mp4
│ ├── 013 Joins – The Hash Join.mp4
│ ├── 014 Parallelism Introduction.mp4
│ ├── 015 Terminology.html
│ ├── 016 Summary.html
│ └── 017 Quiz Quiz.html
├── 03 Cost Estimation
│ ├── 001 Statistics Contain 3 Key Pieces of Information in DBCC SHOW_STATISTICS.mp4
│ ├── 002 Quick Review.html
│ ├── 003 Anatomy of a Statistic Header,Vector and Histogram.mp4
│ ├── 004 Out of Date Statistics.mp4
│ ├── 005 Stale Statistics Demo.mp4
│ ├── 006 Maintaining Statistics.mp4
│ ├── 007 Setting Up Statistics Maintenance Job.mp4
│ ├── 008 Terminology.html
│ ├── 009 Summary.html
│ └── 010 Quiz Quiz.html
├── 04 Real World Examples Fixing the Most Common Issues
│ ├── 001 The Scan On Large Tables.mp4
│ ├── 002 Using SET STATISTICS IO ON.mp4
│ ├── 003 SET STATISTICS PROFILE ON.html
│ ├── 004 Non-Clustered Indexes on Heaps.mp4
│ ├── 005 The No Good Sort Operator.mp4
│ ├── 006 Unwinding The Spool.mp4
│ ├── 007 Summary.html
│ └── 008 Quiz Quiz.html
└── 05 Conclusion
└── 001 Congratulations and Thank You.html