Improve bcp Performance

There are three ways to improve the performance of bcp.

• Fast, Fast-logged, and Slow bcp
  Whether to use fast, fast-logged, or slow bcp depends on your situation.
• Summary of Steps for Fast and Fast-logged bcp
  The various steps available for fast and fast-logged bcp can be performed by various users.
• Bulk Copying Data into Partitioned Tables
  In certain circumstances, you can improve bcp performance dramatically by executing several bcp sessions with a partitioned table.
• Using Parallel Bulk Copy to Copy Data into a Specific Partition
  Use parallel bulk copy to copy data in parallel to a specific partition. Parallel bulk copy substantially increases performance during bcp sessions because it can split large bulk copy jobs into multiple sessions and run the sessions concurrently.