SQL Server: Common Query Tuning Problems and Solutions Part 2

Course Introduction
Course Introduction
Course Structure

Troubleshooting Inefficiency
Module Introduction
Demo: One-Row-At-A-Time-Processing
Demo: The Forgotten Trigger
Demo: Scalar Function Inhibited Parallelism
Demo: Scalar Function Row by Row Execution
Demo: Too Few Rows Per Batch
Demo: Not Using TOP When You Can
Demo: Unnecessary Many-To-Many
Demo: Excessive Fragmentation and Scans
Module Summary

Tuning OLTP vs. DSS Patterns
Module Introduction
Defining OLTP and DSS
OLTP Characteristics
Demo: Stop-And-Go Operators
Demo: Finding Timeout-Prone Queries
Demo: Over-Indexing
Demo: OLTP and Parallelism
Demo: OLTP and Deep Trees
DSS Characteristics
Demo: Expanding the AdventureWorksDW2012 Database
Demo: Unwanted Serial Plans
Demo: Aggregation Queries and Columnstore Index Opportunities
Demo: Distinct Aggregation Issue
Module Summary

Advanced Query Tuning Patterns
Module Introduction
Demo: New-Feature Abuse
Demo: Recursive CTE Estimate Skews
Demo: Unmatched Indexes
Demo: Disused Filtered Statistics
Demo: Interpreting RetrievedFromCache
Demo: Amplification and Distinct Value Counts
Demo: Join Hints and Forced Order
Demo: CTEs vs. Derived Tables
Demo: One Procedure With Multiple Optional Input Parameters
Demo: Procedure Sub-Branching
Demo: Verifying Instance Workload Complexity
Module Summary
Course Summary