SQL Saturday 294

June,7th 2014
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. 
http://www.sqlsaturday.com/viewsession.aspx?sat=294&sessionid=19957
Please find my presentation materials here:
http://1drv.ms/1k7MjFZ

Thanks for attending
Mark

Labels: