Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindex all tables routine
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01513352
Message ID:
01513410
Views:
33
>>See this one
>>http://sqlfool.com/2010/04/index-defrag-script-v4-0/
>>
>>and (http://serverfault.com/questions/80307/best-way-to-rebuild-all-indexes-on-all-tables-in-sql-server-2005/80352)
>>
>>http://ola.hallengren.com/
>
>I did not look at the third one, but the other two seem to be the same, and it seems that they just defrag, not rebuild the indexes (the store procedure was way too long to me to pay attention) :)

Look closer at the comments in the first SP

@rebuildThreshold defaulted to 30% as recommended by Microsoft in BOL;
greater than 30% will result in rebuild instead

I also suggest to take a closer look at the third link.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform