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.