Troubleshooting Your First Low-performing T-SQL Query

Focused View

Jared Westover

2:02:14

63 View

1. Course Overview

1. Course Overview.mp4

01:26

02. Asking Questions about a Query

01. Introduction.mp4

02:00

02. What Is Low-performing.mp4

02:28

03. Developer Expectations.mp4

02:13

04. Demo - Setup Your Environment.mp4

05:24

05. Start With Questions.mp4

02:27

06. Demo - Ask Questions.mp4

03:59

07. Breakdown Complex Queries.mp4

02:16

08. Demo - Common Table Expressions.mp4

02:30

09. Demo - Nested CASE Expressions.mp4

03:15

10. Summary.mp4

01:23

03. Sources of Query Performance Issues

01. Introduction.mp4

01:47

02. Clicking Execute.mp4

02:18

03. SQL Server Storage.mp4

01:41

04. Return Fewer Pages.mp4

01:57

05. Demo - Page Count.mp4

02:51

06. Demo - Returning Fewer Pages.mp4

03:18

07. Indexes Drive Performance.mp4

02:06

08. Invalidate Index Seeks.mp4

01:30

09. Demo - Invalidate Index Seeks.mp4

03:32

10. Do You Need All the Columns.mp4

01:49

11. Demo - Problem With Select.mp4

02:17

12. Summary.mp4

01:33

04. Performance Insights with SQL Server Tools

01. Introduction.mp4

02:04

02. Query Tuning Diminishing Returns.mp4

02:40

03. Calculate Page Reads.mp4

02:50

04. Demo - STATISTICS IO.mp4

04:39

05. Exploring an Execution Plan.mp4

02:19

06. Important Plan Operators.mp4

02:08

07. Demo - Reading an Execution Plan.mp4

04:03

08. Demo - Important Plan Operators.mp4

04:23

09. Dynamic Management Objects.mp4

02:51

10. Demo - Missing Indexes & Top Queries.mp4

03:38

11. Summary.mp4

01:17

5. Query Tuning in the Real World

1. Introduction.mp4

02:10

2. Demo - Covering Index.mp4

04:38

3. Demo - Filtered Index.mp4

04:45

4. Demo - Index Column Order.mp4

05:08

5. Demo - Using Compression.mp4

05:30

6. Demo - Rethinking Cursors.mp4

04:47

7. Demo - User-defined Function Improvements.mp4

04:31

8. Take the Next Steps.mp4

01:53

Description

Are your SQL queries running slower by the day? Does writing new queries make you worry? If so, this course is for you! You will discover valuable tools built into SQL Management Studio to aid in reducing query execution times.

What You'll Learn?

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, which is paramount in improving performance. Then, you will learn the internals of how SQL Server stores and retrieves data.

Next, you will discover tools built into SQL Server Management Studio, which 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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Jared Westover

Instructor's Courses

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data gives Jared a chance to combine his passions for technology and creativity. Tracking data, whether steps taken or money spent, has become an obsession. He loves spending time with his wonderful wife Amanda and three children in his spare time. Jared enjoys lifting weights, along with a good Netflix binge.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.