Viewing 2 posts - 1 through 2 (of 2 total)
e-book - SQL Server 2000 Administrator's Pocket Consultant
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/adminpoc.mspx
A very good read (and free!)
May 9, 2006 at 7:17 am
#636721
I wouldn't de-frag/reindex/set any optimizations for SYSTEM databases.
According to books on line:
'DBCC DBREINDEX is not supported for use on system tables. '
Regards,
Satveer.
January 17, 2006 at 8:52 am
#615187