Home Forums SQL Server 2012 SQL 2012 - General Fast inserting\reading\deleting of millions of records RE: Fast inserting\reading\deleting of millions of records

  • March 19, 2014 at 2:06 pm

    #1698516

    darren_ferris (3/19/2014)

    This causes more of an issue with the underlying stored procedures and the maintenance of them as we have to use lots of dynamic SQL that becomes difficult to write, understand and debug.

    That shouldn't be true. Dynamic SQL is actually pretty easy to write, debug, and maintain if you do it right. Do you have an example of the Dynamic SQL you're using so that I might be able to make a suggestion?

    --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)