When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible?

In this session, you will learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is happening behind the scene of minimal logged inserts, why they are so important when doing bulk load, and what is required to achieve a minimal footprint on the transaction log.

(no tags)