SQL Server Performance: Introduction to Query Tuning
Pluralsight
Course Summary
SQL Server performance tuning is an art to master - for developers and DBAs alike. This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems. This includes an introduction to understanding execution plans inside SQL Server.
-
+
Course Description
SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
-
+
Course Syllabus
Introduction- 10m 22s
—Introduction 2m 58s
—Query Tuning 2m 38s
—Demo 4m 46sExecution Plan Basics- 45m 59s
—Introduction 4m 1s
—Demo 5m 58s
—Various Execution Plan Types 3m 4s
—Demo: Execution Plan Types 5m 24s
—Clustered Index 4m 23s
—Demo: Clustered Index 4m 8s
—Non-clustered Index 1m 42s
—Demo: Non-clustered Index 3m 50s
—Key Lookup 0m 48s
—Demo: Key Lookup 3m 19s
—Index Seek vs Index Scan 1m 42s
—Types of Joins 1m 54s
—Demo: Types of Joins 4m 33s
—Summary 1m 13sEssential Indexing Techniques- 20m 19sQuery Design for Performance- 50m 16sPerformance Tuning Tools- 1h 15mTips and Tricks- 25m 53sChecklist: Performance Tuning- 7m 13s