Microsoft® SQL Server 2012 Unleashed

Parallel Loading

A great enhancement of bcp is that you can now use it to do parallel loads of tables. If you want to take advantage of this feature, the following must be true:

The bulk-copy operation must be nonlogged; all requirements specified in the previous discussion on nonlogged operations must be met.

There must be no indexes on the target table.

Only applications using the ODBC or SQL OLE DB-based APIs can perform parallel data loads into a single table.

The procedure is straightforward. After you ascertain that the target table has no ...