SQL Server: Copying Data From One Table To Another

Insert With Indexes Enabled – Import Abandoned After An Hour

Insert With Indexes Disabled – Import and Index Rebuild Finished After 23 Minutes

Insert With Tab Lock and Indexes Disabled – 21 Minutes

you find details about that: Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.