7 Tips to Performance Tuning, Optimization, and Everything

on YouTube ↗01h 00m

" summary

Seven concrete tactics and measured outcomes: converting scans to seeks with a covering index with INCLUDE; replacing functions with computed columns and indexing them to eliminate key lookups; keeping auto statistics produces a 37% vs 63% cost split in the demo; delayed durability drops a 100k-row insert from ~13s to ~2s; an in-memory table insert runs near instant; enabling trace flag t6534 collapses an 18s geometry build to 0s.

AI-written summary · about

" chapters (12)

1. 0:00Start
2. 1:05Technical Assistance
3. 2:21PASS SUMMIT 2015
4. 3:34Explore Everything PASS Has to Offer
5. 6:27Pareto Principle
6. 6:57THE RULE OF 80/20
7. 7:11Cover Indexes
8. 14:58Functions and Performance
9. 40:37Auto Statistics On/Off
10. 42:08Delayed Durability
11. 48:04Tip 21: In-Memory Database Table
12. 52:28Tip 29: Geometry Datatype

" related talks

• 43mPerformance Tuning, Getting the Biggest Bang for Your BuckMonica Rathbun · SQL Server Virtual Conference 2021
• 54mYour Performance Tuning Check ListMonica Rathbun · SQLBits 2024
• 50mImproving Postgres' EfficiencyAndres Freund · PostgresOpen Silicon Valley 2017
• 44mImproving Performance with Intelligent Query ProcessingJohn Morehouse · SQL Server Virtual Conference 2021
• 57mYour Performance Tuning Check ListMonica Rathbun · Women Data Summit 2021
• 24mTop 5 PostgreSQL Query Tuning TipsJanis Griffin · Postgres Conference Orlando 2025
• 26mThe five-step guide to SQL tuningConnor McDonald · Oracle CloudWorld 2022
• 25mThe Secret Life of SQL: How to Optimize Database PerformanceBryana Knight · RailsConf 2017