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

Buy now

Advanced Query Tuning Part 2

Query Tuning WIth Rewrites PDF And Demos.zip

24.5 MB

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