At SQL Saturday - Philadelphia I presented on how to optimize bulk insert operations - a discourse on how to gain minimal logging and considerations for ETL development:
Optimizing Bulk Insert Operations
Why is the ETL slow? How come this simple insert takes so long? What is minimal logging and how can this be achieved? This session will explore how to improve the performance of bulk insert operations with consideration to database settings, indexes, constraints and trace flag 610. We will compare performance between different methods of bulk insert and discuss how each can be tuned for better performance.
Please find my presentation materials here:
Thanks for attending