DBCC SHOWCONTIG Returns 0 pages scanned

Question

DBCC SHOWCONTIG Returns 0 pages scanned

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

There is one pesky problem DBCC SHOWCONTIG is obsolete in 2005 you use sys.dm_db_index_physical_stats instead try the link below for details. Why the indexes are owned by the ANSI SQL manufacturers like Microsoft so in 2005 most things you know about indexes in 2000 was replaced. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms188917.aspx

Kind regards,
Gift Peddie

rbandyo Old Hand Points: 372 More actions · Answer 2

rbandyo

Old Hand

Points: 372

October 9, 2007 at 11:43 am

#740467

Thanks, that helped a lot.

Regards

Rupendra