• and before anyone follows that up with "it's not disk fragmentation" - what i mean is , it's the fragmentation of the index within the data file (not the fragmentation of the file on the disk)

    the sys.dm_db_index_physical_stats gives you information about the contiguity and wasted space in the files at both a logical and physical level.

    MVDBA