COLUMNS_UPDATED() and Triggers

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

  • 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 1 (of 1 total)

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