Tag Archives: sql index neuaufbau osql transact

SQL Index Neuaufbau über Transact SQL

–Rebuild all indexes online with keeping the default fill factor for each index USE [DATABASE_NAME] EXEC sp_MSforeachtable @command1=“print ‚?'“, @command2=“ALTER INDEX ALL ON ? REBUILD WITH (ONLINE=ON)“ –Rebuild all indexes offline with keeping the default fill factor for each index USE [DATABASE_NAME] EXEC sp_MSforeachtable @command1=“print ‚?'“, @command2=“ALTER INDEX ALL ON ? REBUILD WITH (ONLINE=OFF)“ –Rebuild […]

Read more