Setup SQL Plan Baselines

Topics covered include:
Comparison of SQL Profile and SQL Plan Baselines
Automatic and Manual setup of SQL Plan Baselines
Copying SQL Plan Baselines to another database

SQL Plan Baselines.html

Manage SQL Profiles

Topics covered include:
Setting parameters for SQL Tuning Advisor
Manually create a tuning task
Activating a SQL Profile
Copying SQL Profiles to another database

Manage SQL Profiles.html

SQL Performance Tuning

Notes on SQL Performance Tuning

Topics covered include:
Determing if the Optimizer estimations are correct
Is an Index necessary and on which columns
Should hints be used and which ones to consider.

Notes on SQL Performance Tuning(pdf)