sqlnaive (12/28/2012)
Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.
Both of those were deprecated 7 years ago, are included only for backward compatibility with SQL 2000 and should not be used any longer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability