- Course
- Data
SQL Server Performance: Introduction to Query Tuning
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.
What you'll learn
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.
Table of contents
- 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 | 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 13s
About the authors
Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a well-known speaker at all major Microsoft and third party technical conferences.
Pinal Dave is a Pluralsight Developer Evangelist.