Rebuilding SQL Indexes - When?
indexing, t-sql
Solution
It depends on the fragmentation levels not on the timeframe in general, check out the Automated Index Defrag Script here by Michelle Ufford, it will check the fragmentation levels and only rebuild/reorg when needed
Problem
When should one rebuild indexes? Nightly? Weekly? Hourly?