Optimize Query Performance in SQL Server
SQL Server query plans
Types of query plans
Estimated and actual query plans
Identify problematic query plans
Read a query plan
Lightweight query profiling
The last query plans stats
Hardware constraints
Suboptimal query constructs
SARGArbility
Missing indexes
Missing and out-of-date statistics
Poor optimizer choices
Parameter sniffing
Evaluate performance improvements
Dynamic management views and functions
Wait statistics
Tune indexes
Maintain indexes
Columnstore maintenance
Performance-based design
Normalization
First normal form
Second normal form
Third normal form
Denormalization
click to edit
Design indexes
Clustered indexes
Non-clustered indexes
Columnstore indexes
Data compression
Row compression
Page compression
Columnstore archival compression