codebyo (9/8/2011)
In the company I work for we don't have DBAs so it's basically us developers doing the dirty work. After some analysis I found out that almost all of the indexes which are highly fragmented are ones which had columns added somewhen.
Unless you're adding columns every second week, most of the fragmentation should be from inserts and updates, or maybe (horror) from database shrinks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability