Query performance

Checklist for Analyzing Slow-Running Queries

http://technet.microsoft.com/en-us/library/ms177500.aspx

Advanced Query Tuning Concepts

http://technet.microsoft.com/en-us/library/ms191426.aspx