To Toad for SQL Server community
Alter Table syntax need to move Index Creation after Insert
On Table Alters where the DBA is adding a new column and putting it into a specific ordinal position (not just the end) it would BEST to avoid lengthy insert (76million rows) by moving the INDEX creation to after the insert statement. Doing so could have hours on the insert if the table is wide as well as deep regardless of the hardware.
Social Web