- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
SQL Server Performance: Introduction to Query Tuning
Intermediate
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
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.