>I would like to collect information as to know how often do you apply a full reindexation of your tables. I have received all kinds of feedback so far but this is not concreate. Some says they are doing it on a weekly basis, some annual and so on. Are you really gaining of seeing an improve of performance when doing that?
We rebuild indexes daily, but we have a fair amount of CRUD.
Don't forget about reorganizing indexes. Fragmentation greater than 10% but less than 30% (IIRC) suggests that index be reorganized rather than rebuilt. SQL Server can reorganize indexes without making them inaccessible which means no down time, though I would recommend doing reorgs during off-peak hours.
SQL Server Enterprise allows rebuilding of indexes while leaving them online for 24/7/365 uptime goals.
Brandon Harker
Sebae Data Solutions