• Gary Varga (8/19/2014)


    Jeff in my experience most DBAs improving stored procedures or operational scripts do so with the purpose of refinement and optimisation (performance, resource usage, etc.), however, most 3GL developers rewrite applications and services from scratch without a measurable outcome.

    Since this is an SQL Forum, I made the poor assumption that this was about Developers (front-end or database) that were spending some time on T-SQL. That, notwithstanding, I also appreciate front-enders that will take the time to reduce transmission requirements and increase performance by reducing the God-awful amount of HTML that a lot of programmers never give a second thought to.

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