Tuning Query Performance

SQL Query Performance Tuning

TechNet: Optimizing SQL Server Query Performance

http://technet.microsoft.com/en-us/magazine/2007.11.sqlquery.aspx

Query Execution Plans

TechNet: Execution Plan Caching and Reuse

http://technet.microsoft.com/en-us/library/ms181055%28SQL.90%29.aspx

Dynamic Management Views

Best Practices for Dynamic Management Views
http://blogs.msdn.com/heynen/archive/2008/06/28/best-practices-for-dynamic-management-views.aspx

SQL Profiler

Microsoft TechNet: Using SQL Profiler
http://technet.microsoft.com/en-us/library/cc966515.aspx

Database Engine Tuning Advisor

MSDN: Database Engine Tuning Advisor Overview
http://technet.microsoft.com/en-us/library/ms173494.aspx