Understanding Query Optimization in SQL Server

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

Retrieving the data from SQL Server is something that every data professional should know. However, retrieving the data from SQL Server in an efficient and performant way is a mastery of its own!

1. Course Overview

1. Course Overview

2. Introducing Query Optimization in SQL Server

1. Introducing Query Optimization in SQL Server

2. Introducing SQL Server Query Optimizer

3. Understanding the Stages of the Query Optimization Process

4. Demo - Capturing Query Performance Metrics

3. Understanding Query Plans

1. Understanding Query Plans

2. Reading and Interpreting the Query Plan

3. Demo - Analyzing and Comparing Query Plans with SSMS

4. Understanding Plan Reuse and Plan Cache

1. Understanding Plan Caching

2. Demo - Querying Plan Cache for Ad Hoc and Prepared Workloads

5. Understanding Indexing and Statistics

1. Introduction to Indexing with SQL Server

2. Index Design Recommended Practices

3. Demo - Understanding Query Performance with Indexes

4. Understanding Statistics

5. Demo - Understanding Query Performance with Statistics

6. Optimizing Ad-hoc Expressions and Parameterization

1. Demo - Optimizing for Ad Hoc Workloads

2. Understanding Parameter Sniffing

3. Demo - Parameter Sniffing and Recompiling

7. Understanding Plan Guides and Query Hints

1. Understanding Plan Guides

2. Demo - Optimizing Performance with Query Hints

139,000 تومان

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

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

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

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