COLUMNS_UPDATED() and Triggers

  • habib

    SSC Enthusiast

    Points: 182

    Comments posted to this topic are about the item COLUMNS_UPDATED() and Triggers

  • Tore Bostrup-382308

    Old Hand

    Points: 348

    Good article.  One thing to note - the INFORMATION_SCHEMA performance in some versions of SQL Server may be problematic in triggers.  When I first converted a system to the new Cardinality Estimator (SQL 2014 at the time), triggers that used it had their performance drop to the floor.  Use the system views instead.


    Regards,

    Tore Bostrup

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply