COLUMNS_UPDATED() and Triggers

• habib

  SSC Enthusiast

  Points: 182

  More actions

  July 8, 2019 at 12:00 am

  #3659404

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

• Tore Bostrup-382308

  SSC-Addicted

  Points: 448

  More actions

  July 8, 2019 at 3:37 pm

  #3660817

  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.

  • This reply was modified 5 years, 11 months ago by Tore Bostrup-382308.

  ---

  Regards,

  Tore Bostrup