SQL Index rebuild

#1 · 19. Februar 2021, 18:30

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