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.
Viewing 2 posts - 1 through 1 (of 1 total)