Darling Data/Advanced Query Tuning Part 1

  • $99.95

Advanced Query Tuning Part 1

  • Course
  • 34 Lessons

Everything is on the table here. These are the things a DBA must know to fix the problems everyone else thinks are too hard to solve. You'll learn innovative techniques to solve problems no matter what your situation is. This video will cover parameter sniffing, lookups, sorts, functions, optional parameters, paging, and how to tune those gigantic queries that bring your server crashing down. 4.5 Hours, Streamed

Contents

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

A Blueprint For Tuning

Intro
Information vs. Relational
Clear Predicates
Adequate Indexes
Manageable Logic
Recap

Blueprint - Parameter Sniffing

If-Branching Does Not Work
If-Branching Does Not Work - Demo
Parameter Sniffing Intro
Optional Recompile
Optional Recompile - Demo
Optimize For You
Optimize For You - Demo
Temp Table
Temp Table - Demo
Recap

Blueprint - Lookups

Intro
Predicate Lookups
Predicate Lookups - Demo
Fixing Lookups With TOP
Fixing Lookups With TOP - Demo
Lookups and Relational CTEs
Lookups and Relational CTEs - Demo
Recap

Blueprint - Sorts

Intro
Indexes
Indexes - Demo
Missing Indexes Demo
Indexes Are Not The Problem
Indexes Are Not The Problem - Demo 1
Indexes Are Not The Problem - Demo 2
Recap