Fastest Way to load bulk data
Posted by decipherinfosys on May 3, 2009
A very common question that you will face when working on any project that involves ETL (Extract Transform and Load) or even some data feeds developed using SSIS is that how can I get my data into SQL Server in the fastest possible way. What are the different factors that influence the performance and how does the combination of recovery models, different bulk load methods work for the different scenarios and what are the different parameter options that can be used for those methods in order to tweak them a bit more and get the best performance?
Here is an excellent whitepaper by Microsoft on this topic and it covers all these details: