OLDCHAPPY (12/9/2013)
ALTER INDEX ALL ON dbo.TABLE1 REBUILD
ALTER INDEX ALL ON dbo.TABLE2 REBUILD
ALTER INDEX ALL ON dbo.TABLE3 REBUILD
...
ALTER INDEX ALL ON dbo.TABLE783863 REBUILD
Here I think it's good to remind you on the options for the INDEX REBUILD
... (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,
IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
COMPRESSION = PAGE)
ON [Index_FG]
because you said you run a script to generate the indexes definitions. Many scripts do not script indexes well, especially regarding these options. You said you'd run compression, and etc.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com