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