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: 368

    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.


    Tore Bostrup

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

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