bcp in works in one of two modes:
Slow bcp – logs each row insert that it makes, used for tables that have one or more indexes.
Fast bcp – logs only page allocations, copying data into tables without indexes or at the fastest speed possible. You can use fast bcp on tables with nonclustered indexes.
To determine the bcp mode that is best for your copying task, consider the:
Size of the table into which you are copying data
Amount of data that you are copying in
Number of indexes on the table
Amount of spare database device space that you have for re-creating indexes
Fast bcp might
enhance performance; however, slow bcp gives
you greater data recoverability.
