To improve the performance of bcp:
Use fast-logged bcp
Use partitioned tables. Several bcp sessions with a partitioned table can reduce dramatically the time required to copy the data. However, such performance improvements are more noticeable in fast and fast-logged bcp than in slow bcp.
Use bcp in parallel to increase performance dramatically. Parallel bulk copy can provide balanced data distribution across partitions. For more information, see “Using parallel bulk copy to copy data into a specific partition”.
bcp does
not fire any trigger that exists on the target table.
