Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document. Highlights Understanding Minimally Logged Operations Trace Flag 610 (sql server 2008) Summarizing Minimal Logging Conditions Bulk Load Methods Integration Services Data Destinations BCP BULK INSERT INSERT ... SELECT SELECT INTO Choosing Between Bulk Load Methods Data Compression and Bulk Load Other Minimally Logged and Metadata-Only Operations Solving Typical Scenarios with Bulk Loading Optimizing Bulk Load Read More View the the Data Load Performance Guide Bulk Insert CSV into a SQL Server table -... Read more →