SQL Server 2005 Query Statistics

Question

Where can I find some in-depth information on tuning statistics in SQL Server 2005?

I need to really delve in to what statistics are being used in a number of different queries, how they are interacting with indexes, how/when/where to use custom statistics (over and above what the database tuning advisor recommends), when/how to update the statistics for the best performance etc. etc.

Does anyone know of any good articles/webcasts/books around this subject?

Thanks in advance,

Tom

Answer 1

This book gives fairly detailed information on performance tuning Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization