Factors Affecting Bulk Copy Performance

To bulk copy data as fast as possible, it is important to understand how data is copied, and what options are available to specify how data should be copied.

• Bulk copy using the query processor
• Logged and nonlogged bulk copies
• Parallel data load using bcp
• Controlling the locking behavior
• Using batches
• Constraint checking
• Ignoring DEFAULT definitions
• Ordered data files

See Also

Optimizing Bulk Copy Performance