fragmentation

As data altered in T-SQL, its indexes become fragmented, perhaps spread across separate files. This is fragmentation and this has some notes on it.