How to Use the SQL Server 2005 Tuning Advisor

Optimize your queries by running the advisor to add needed indexes. Also applies to SQL Server 2008