Check Fragmentation stats SELECT dbschemas . [name] as 'Schema' , dbtables . [name] as 'Table' , dbindexes . [name] as 'Index' , indexstats . alloc_unit_type_desc , indexstats . avg_fragmentation_in_percent , indexstats . page_count FROM sys . dm_db_index_physical_stats ( DB_ID (), NULL, NULL, NULL, NULL) AS indexstats INNER JOIN sys . tables dbtables on dbtables . [object_id] = indexstats . [object_id] INNER JOIN sys . schemas dbschemas on dbtables . [schema_id] = dbschemas . [schema_id] INNER JOIN sys . indexes AS dbindexes ON dbindexes . [object_id] = indexstats . [object_id] AND indexstats . index_id = dbindexes . index_id WHERE indexstats . database_id = DB_ID () ORDER BY indexstats . avg_fragmentation_in_percent desc Rebuild Indexes DECLARE @tsql NVARCHAR ( MAX ) DECLARE @fillfactor INT SET @fillfactor = 90 SELECT @tsql = STUFF...