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