O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

Image 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required