• Index maintenance should be a regular thing, indexes get fragmented for many different reasons, I recommend reading up on indexes and fragmentation, some good links below.

    http://www.sqlservercentral.com/stairway/72399/

    http://sqlinthewild.co.za/index.php/2008/10/20/what-is-fragmentation/