Index Fragmentation–“If it isn’t broken, don’t fix it”

Indexes get fragmented.  It’s a fact of database life and something that every DBA has to deal with but we do get a choice on HOW we deal with it.  The phrase “If it isn’t broken, don’t fix it” is made in reference to SQL Server Maintenance Plans and more specifically the Index Rebuild Task. …