Home Forums SQL Server 2008 T-SQL (SS2K8) Bulk insert slower after upgrade in SQL2008 R2 RE: Bulk insert slower after upgrade in SQL2008 R2
AlBran LVP
SSC Eights!
Points: 857
More actions
August 21, 2012 at 2:55 pm
#1528380
Have you tried deleting all the indexes right before the bulk load and recreating them afterwards? That probably wouldn't explain the difference but it should speed things up substantially.