DEFRAG Indexes 1

[link9]

Hello all --

Long time no see (which is a good thing ;-)) --

I am looking into degragmenting my databases (internally), and have found the:

DBCC INDEXDEFRAG

But am quite dismayed at the prospect of sifting through every single index of every single table of every single database and constructing a query for each... which is what it appears that this command requires me to do.

I'm sincerely hoping beyond hope that one of you fine ladies/gentlemen out there can fix me up with a more efficient way of performing this maintenance -- perhaps on a database by database basis, or better yet, an entire server.

Thanks alot!
paul

 

[sunny456]

link9,

go to BOL and search for DBCC SHOWCONTIG. At the bottom of the page there is a script that I think will help you defrag indexes for an entire db based on maxfrag.

HTH

 

[link9]

Beautiful.

Thanks, sunny456!