SQL Server Performance Tuning Fast Track Video Course – Module 4: Query Tuning (Independent Module)

Note: Yearly Subscription (taxes included)

Module 0: Introduction

Before You Begin The Demos

Module 4: Query Tuning

• Understanding Execution Plan
• Statistics & Cardinality Estimation
• Query Tuning
  • The Bad Bookmark Lookups
  • Expensive Sorts
  • Implicit Conversion
  • Non-SARGability
  • Stale Statistics
  • Parameter Sniffing
  • Re-Writing T-SQL
• Query Store (SQL 2016)
• Automatic Query Tuning (SQL 2017)
• Intelligent Query Processing (SQL 2017 & 2019)
• Demos
• Summary

Module 7: Wrap Up