Search

Saturday, July 30, 2011

Reindex on all tables that doesn't have default fill factor

exec sp_MSforeachtable 'dbcc dbreindex (''?'', '''', 90)'

To reindex all tables in a database with higher or lower fill factor.

run:

exec sp_MSforeachtable @command1='DBCC DBREINDEX(''?'') '

This will reindex all the tables with the fillfactor it orginally was set to. Sometime you can test with different fill factors to get higher performance.

No comments:

Post a Comment