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.
Course info
Rating
(516)
Level
Intermediate
Updated
Jun 1, 2012
Duration
3h 55m
Table of contents
Introduction
Execution Plan Basics
Essential Indexing Techniques
Query Design for Performance
Performance Tuning Tools
Tips and Tricks
Checklist: Performance Tuning
Description
Course info
Rating
(516)
Level
Intermediate
Updated
Jun 1, 2012
Duration
3h 55m
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.

About the author
About the author

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.

More from the author
SQL Server Performance: Indexing Basics
Intermediate
1h 59m
Mar 5, 2012
SQL Server Questions and Answers
Intermediate
2h 14m
Jan 24, 2012
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
MariaDB Functions Playbook
Advanced
1h 42m
Nov 13, 2019
MariaDB Data Manipulation Playbook
Intermediate
1h 35m
Nov 12, 2019
More courses by Pinal Dave