Darling Data/Advanced Query Tuning Part 2

  • $99.95

Advanced Query Tuning Part 2

  • Course
  • 38 Lessons

This is Part 2 of videos dedicated to SQL Advanced Performance Tuning Training. We teach you everything a DBA needs to know about parameter sniffing, lookups, sorts, functions, optional parameters, paging, and tuning queries. You’ll become the person to call when a solution seems impossible. 4.5 Hours, Streamed

Contents

Advanced Query Tuning Part 2
Query Tuning WIth Rewrites PDF And Demos.zip

Blueprint - Functions

Intro
Scalar Function Follies
Scalar Function Rewrites
Scalar Function Rewrites - Demo
Scalar Functions - Isolation
Scalar Functions - Isolation - Demo
Scalar Functions - Executions
Scalar Functions - Executions - Demo
MSTVFs
MSTVFs - Demo
Recap

Blueprint - Optional Parameters

Intro
Setup and Recompile Demos
Comparing Dynamic SQL
Recompile and Dynamic SQL
Recap

Blueprint - Paging

Intro
Optimization
Optimization - Indexing - Demo
Optimization - Methods - Demo
Recap

Blueprint - Complexity

Intro
Separating Predicates
Separating Predicates - Demo
Materializing CTEs
Materializing CTEs - Demo
Batch Mode
Batch Mode - Demo
Spools Intro
Eager Index Spools
Eager Index Spools - Demo
Table Spools
Table Spools - Demo
Row Count Spools
Row Count Spools - Demo
Recap