Community

Dynamic defrag of all indexes for a given table

(Robert Davis) Running ‘DBCC INDEXDEFRAG’ on a table can be a big performance boost without the overhead of the full ‘DBCC DBREINDEX’ on high traffic databases. However ‘DBCC INDEXDEFRAG’ carries the overhead of having to specify each index by name or ID rather than just the table. This means your m

Read More - Register for Free Membership