Scott Coleman (8/17/2009)
From Nov 2008 Books Online:DBCC CHECKALLOC checks the allocation of all pages in the database, regardless of the type of page or type of object to which they belong. It also validates the various internal structures that are used to keep track of these pages and the relationships between them.
When you say this does not check statistics, what exactly isn't being checked? It doesn't resample the data and update statistics, but it does check the their logical and physical integrity.
Scott,
It doesn't check the their logical and physical integrity of STATISTICS based on the connect item (https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=158623&wa=wsignin1.0)
There are no references to this fact anywhere else except the connect item and that's what I tried to share with everyone with this quiz.
I have asked Paul Randal to shed some light on this one and hopefully if time permits and if he is interested will share some details.
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]