Troubleshooting Your First Low-performing T-SQL Query

سرفصل های دوره

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.

1. Course Overview

1. Course Overview

02. Asking Questions about a Query

01. Introduction

02. What Is Low-performing

03. Developer Expectations

04. Demo - Setup Your Environment

05. Start With Questions

06. Demo - Ask Questions

07. Breakdown Complex Queries

08. Demo - Common Table Expressions

09. Demo - Nested CASE Expressions

10. Summary

03. Sources of Query Performance Issues

01. Introduction

02. Clicking Execute

03. SQL Server Storage

04. Return Fewer Pages

05. Demo - Page Count

06. Demo - Returning Fewer Pages

07. Indexes Drive Performance

08. Invalidate Index Seeks

09. Demo - Invalidate Index Seeks

10. Do You Need All the Columns

11. Demo - Problem With Select

12. Summary

04. Performance Insights with SQL Server Tools

01. Introduction

02. Query Tuning Diminishing Returns

03. Calculate Page Reads

04. Demo - STATISTICS IO

05. Exploring an Execution Plan

06. Important Plan Operators

07. Demo - Reading an Execution Plan

08. Demo - Important Plan Operators

09. Dynamic Management Objects

10. Demo - Missing Indexes & Top Queries

11. Summary

5. Query Tuning in the Real World

1. Introduction

2. Demo - Covering Index

3. Demo - Filtered Index

4. Demo - Index Column Order

5. Demo - Using Compression

6. Demo - Rethinking Cursors

7. Demo - User-defined Function Improvements

8. Take the Next Steps

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight