Explore performance tuning wisdom for SQL Server in this 57-minute conference talk from the PASS Data Community Summit. Join Brent Ozar and Erik Darling as they challenge conventional wisdom and debunk outdated assumptions about database optimization. Dive into demos covering topics such as indexing strategies, scan vs. seek operations, and the effectiveness of various tuning techniques. Learn why some long-held beliefs about performance tuning may need to be reevaluated and discover fresh approaches to improve your SQL Server's efficiency. Gain insights on table scans, filtering, index design, query store, and Azure performance tuning. Understand the importance of regularly updating your knowledge and adapting to evolving best practices in database management.
Overview
Syllabus
Introduction
Brent and Eric introduction
Demos
Table scans
Filtering
Indexes
Free Plan Cache
Force Index Seek
Logical Reads
Fill Factor
Drop Indexes
Index on Display Name
Missing Index Hint
Testing Missing Index Hint
Testing Cortana
Stack Overflow Overflow Post
Hash Match
Index Recommendation
Index Scan
Index Design
Order By
Sort
Index
Grouping
Indexing
Missing Index DMV
Sikh
Questions
Issues of change
Tuning indexes
Sorting
Missing Index Requests
Asynchronous Indexing
Brents 5 Rule
Does the 5 Rule Include Columns
Is it better to leave it as a heap
Columnstore vs Columnstore
Querystore
SP Blitz Index
Azure Performance Tuning
Robot Interpretive Dance
Taught by
PASS Data Community Summit
