TSQL - Rebuild all indexes that does not have fillfactor = X

Post date: Apr 9, 2013 2:06:04 PM

SELECT 'ALTER INDEX ['+i.name+'] ON ['+SCHEMA_NAME(o.schema_id)+'].['+o.name+'] REBUILD PARTITION = ALL WITH (FILLFACTOR = 90)' FROM sys.indexes iINNER JOIN sys.objects o ON i.object_id = o.object_idWHERE fill_factor <> 90