Paul Randal (8/18/2009)
ok - this isn't a good question. I wrote DBCC CHECKDB and I got the answer wrong. I guess it could be down to BOL stating that disabled indexes aren't checked - yes they are to an extent, as long as the pages in them are still allocated then they will be checked - and have to be. The nonclustered index cross-checks aren't done for them, but allocation checks etc are checked.Nice twist with the stats on the last answer - CHECKDB has never checked the stats blob.
Paul,
Thanks for responding to this. The information you shared above is only privy to you [:(] and not public knowledge of whats checked against not checked for disabled indexes. BOL and your blog are the only sources of information. Can we expect a blog post on this and STATISTICS?
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]