Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindex all tables routine
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01513352
Message ID:
01513410
Vues:
34
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform