Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Data Loading Performance Guide

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

 View the the Data Load Performance Guide

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.