November 17, 2016 at 12:34 am
Dear all,
I wanted to know the steps to take to fix/control index fragmentation. I have found out tables which are fragmented but I'' not sure the next steps to take in order to control defragmentation.
Thank you in advance!
November 17, 2016 at 3:13 am
This was removed by the editor as SPAM
November 17, 2016 at 3:21 am
Rather than roll your own, I would use one of these
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
both are great, take your pick according to your needs
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 17, 2016 at 4:06 am
Another third party tool to check out is Minion Ware. They have a free version of an index management software that does a fantastic job of managing your indexes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply