Home Forums SQL Server 2014 Administration - SQL Server 2014 Adding multiple triggers to same table - Recommendations/Best Practices RE: Adding multiple triggers to same table - Recommendations/Best Practices

  • February 19, 2018 at 12:56 pm

    #1980333

    SQL!$@w$0ME - Monday, February 19, 2018 12:12 PM

    Do you think transactional replication is a good choice for 500 tables. Any performance impact on one vs the other?Thanks!

    Heh... "It Depends".  Will the Oracle box always be online?  And, no... not trying to impart any irony there.  I'd ask the same question about another SQL Server.  Log files can explode on a busy system if the target goes down.

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