Follow me on Twitter for DBA,SQL Server,DB2 and Performance Tuning very large databases infomation.
Email +Jack Vamvas at email@example.com for any other questions. I do try and respond as quickly as possible. These posts may help you with urgent issues, also use the Search feature for other posts.
How to troubleshoot a slow running query in SQL Server
Current queries executing on SQL Server
Find high impact queries with sys.dm_exec_query_stats
How to progress your DBA career
Tuning expert makes SQL Server faster