SQL Server 2005 Query Statistics

views:

181

answers:

+2 Q:

SQL Server 2005 Query Statistics

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

+5 A:

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

Adamski 2009-07-06 15:34:40

@Tom: I highly recommend the entire "Inside SQL Server" series, each volume in the series is invaluable.

Remus Rusanu 2009-07-06 16:32:25

That is a great book, but I couldn't find anything massively detailed about statistics.

Tom Ferguson 2009-07-07 14:37:56

+1 A:

I suggest you review the following comprehensive Microsoft TechNet reference.

Statistics Used by the Query Optimizer

John Sansom 2009-07-06 15:37:12

This article provides just the kind of information I'm after, thanks!

Tom Ferguson 2009-07-07 14:37:20

@Tom Ferguson: You're welcome. Glad to help.

John Sansom 2009-07-07 15:53:35

+1 A:

I suggest you visit http://sqlserverpedia.com/ and look for blog/article/demo/screencast/podcast specific to your needs. SQLServerPedia is a free Premier Online SQL Server resource.

Or are you specifically asking these questions right now:

"Why is this query running slow? Is my index getting used? Why does this query run faster than this query?"

The book "Dissecting SQL Server Execution Plans" will help you on this regard. A free ebook version is available here.

;-) MarlonRibunal

MarlonRibunal 2009-07-06 17:27:45

ansaurus

tags:

views:

answers:

SQL Server 2005 Query Statistics

related questions