SQL Server Performance

commit every 1000 transactions in an insert

Discussion in 'Getting Started' started by avk, Sep 12, 2009.

  1. avk New Member

    Hi,
    Can you please help me find how to commit every 1000 transactions in an insert.
    Thanks,
    avk
  2. moh_hassan20 New Member

    it depends.
    what tool /script you use?
    for bcp you can control using patch size.

Share This Page