Viewing post 1 (of 2 total)
"Insert Into" with a large amount of records will run a long time because SQL Server does the whole insert in one transaction. Use a data pump (Data Flow Task)...
February 24, 2010 at 10:25 am
#1124381