SQL Server Performance Tuning Fast Track Video Course – Module 4: Query Tuning (Independent Module)

Home/Video Course/SQL Server Performance Tuning Fast Track Video Course – Module 4: Query Tuning (Independent Module)

SQL Server Performance Tuning Fast Track Video Course – Module 4: Query Tuning (Independent Module)

$109.00

Note: Yearly Subscription (taxes included)

Module 0: Introduction

Before You Begin The Demos

Module 4: Query Tuning

  • Understanding Execution Plan
  • Statistics & Cardinality Estimation
  • Query Tuning
    • The Bad Bookmark Lookups
    • Expensive Sorts
    • Implicit Conversion
    • Non-SARGability
    • Stale Statistics
    • Parameter Sniffing
    • Re-Writing T-SQL
  • Query Store (SQL 2016)
  • Automatic Query Tuning (SQL 2017)
  • Intelligent Query Processing (SQL 2017 & 2019)
  • Demos
  • Summary

Module 7: Wrap Up

Category:

Description

Module 0: Introduction

Before You Begin The Demos

Module 4: Query Tuning

  • Understanding Execution Plan
  • Statistics & Cardinality Estimation
  • Query Tuning
    • The Bad Bookmark Lookups
    • Expensive Sorts
    • Implicit Conversion
    • Non-SARGability
    • Stale Statistics
    • Parameter Sniffing
    • Re-Writing T-SQL
  • Query Store (SQL 2016)
  • Automatic Query Tuning (SQL 2017)
  • Intelligent Query Processing (SQL 2017 & 2019)
  • Demos
  • Summary

Module 7: Wrap Up

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Content missing