Understanding DBCC Show_Statistics

In this video we continue our look at statistics by looking at some of the output from DBCC Show_Statistics. Just knowing how to read the header line can really help you in your troubleshooting!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Feodor Georgiev on 12/14/2009

Great!

valluru raghu on 12/14/2009

EXCELLENT

John O'Sullivan on 12/14/2009

a very goosd series on Statistic

rajani on 12/14/2009

this video was good

veeresh on 12/14/2009

Very Good One

DD374067A6 on 12/14/2009

excellent

Nasar Azam on 12/14/2009

It was a great video. Looking forward to more dbcc commands in future

C68D83021C on 12/14/2009

Great Video. I have used this in the past and it has helped. I still learned a few things. What would be the best way to find duplicate Indexes and Statistics on a column so we could eliminate the extra ones?

Steve Harris on 12/14/2009

excellent presentation

82857E37DA on 12/14/2009

Talking really fast!!

srininvas on 12/14/2009

great videa

luther smith on 12/14/2009

Vwery clear.

Nancy Lytle on 12/15/2009

Good information I didn't know and now I can use

Piyush on 12/16/2009

Thanks, One question here, what do you mean by sampling here?

Sam Schafer on 12/17/2009

Well done. Good explanation, easy to understand.

Sandip on 12/19/2009

Thanks. Very clear and excellent way to present.

1F2E95B4D1 on 12/31/2009

andy warren is the best you have. he explains things clearly and gives you enough information to begin investigating your system.

J Matheson on 5/4/2010

easy to understand

Hossam on 1/29/2012

Did not explain some terms (e.g. density, selectivity, ..etc) but it is a good introduction. Thanks.