dbcc showcontig with tablersults

DBCC SHOWCONTIG WITH TABLERESULTS will show a ROW column for an index's row count. However, on an important table with quite a few indexes that I am using as a baseline, ROW is NULL for all indexes. Why? BOL definines ROWS as:-

"Number of data or index records at that level of the index. For a heap, this is the number of data records in the entire heap."

By the way, if I select from sysindexes for a one of the above indexes, there is a correct rowcount for the index.

Any ideas?

CliveI found it. I was using the 'WITH FAST' parameter. Without FAST, it returns the row count.

Clive

DBCC commands

What are the important DBCC commands I need to run regularly on my SQL server2000 database?In the future, please make sure that you are posting to Forum, as opposed to the Articles section of this site. I have moved this thread, and expect you will see more responses due to it's proper location on our site.|||I shouldn't expect that any of the dbcc commands would be executed regularly on a server. Typically your DB Admin would set up a maintenance package to perform these actions without affecting your server's performance.