Systems Engineering and RDBMS

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:

http://msdn.microsoft.com/en-us/library/dd425070.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: