Rebuild Only the Indexes that Need Help

A common misconception among SQL Server DBAs is that they need to rebuild their indexes often—even as often as every night. The theory is that, to be effective, indexes can’t have any fragmentation. Another common misconception about indexes is that if you don’t rebuild them frequently, they’ll become corrupted, and then you’re in a HEAP of trouble. (Apologies for the pun.)

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=99019