• Understood but, done properly, audit tables are never a performance problem nor a maintenance problem. Putting the audit tables on a separate server brings all sorts of problems to the table including (but not limited to) the cost of additional licensing, maintenance of another server (backups, disk size monitoring, security, etc), and does nothing to alleviate the problems associated with index and stats maintenance never mind the complexities of sending data to and reading from that other server.

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