Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning BCP vs. OPENDATASOURCE RE: BCP vs. OPENDATASOURCE

  • December 28, 2008 at 2:31 pm

    #918201

    SQL Server uses BCP to do replication... that should be the answer right there. And, if you use the NATIVE mode (like replication does), you don't have to worry about datatypes and all that.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)