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 ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
