Troubleshooting Your First Low-performing T-SQL Query

Are your SQL queries running slower by the day? Does writing new queries make you worry? Well, this course is for you! You will discover valuable tools built into SQL Management Studio to aid in slaying query execution times.
Course info
Rating
(32)
Level
Beginner
Updated
May 17, 2019
Duration
2h 37m
Table of contents
Description
Course info
Rating
(32)
Level
Beginner
Updated
May 17, 2019
Duration
2h 37m
Description

Perhaps you’re starting out or have been plagued by low performing T-SQL queries for years. Maybe you have been appointed the new SQL expert but your query tuning skills are lacking. In this course, Troubleshooting Your First Low-performing T-SQL Query, you will gain foundational knowledge of improving query performance. First, you will hear what vital questions can be asked about a query. Understanding the intent of what data your query is returning back is paramount in improving performance. Along the way, you will learn the internals of how SQL Server stores and retrieves data. Next, you will discover tools built into SQL Server Management Studio. These tools are vital for exploring the SQL Server internals. Finally, you will explore several low performing queries utilizing your newly acquired skills to improve performance. When you’re finished with this course, you will have the skills and knowledge necessary to consistently improve low performing queries.

About the author
About the author

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.

More from the author
Implementing SSRS Report Layouts
Beginner
2h 15m
Aug 28, 2020
More courses by Jared Westover
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is Jared Westover, and welcome to my course Troubleshooting Your First Low‑performing T‑SQL Query. I'm a SQL architect and a Microsoft Certified Solutions Expert in data management and analytics. Most importantly, I love working with data. Knowing how to retrieve data faster is crucial for anyone working as a data analyst or report writer. In this course, we're going to step into the shoes of a junior SQL developer and learn how to make our queries perform better. Having knowledge of SQL Server and prior experience with writing queries will be helpful as you go through the course. Some of the major topics that we will cover include what questions you should be asking about your queries, how to break down a complex query into smaller pieces, how SQL Server retrieves data, and the basics of reading an execution plan. By the end of this course, you will have a solid foundation in troubleshooting SQL Server queries which are not performing at their full potential. I hope you'll join me on this journey to learn query tuning with the Troubleshooting Your First Low‑performing T‑SQL course at Pluralsight.