For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.
Paul White (@SQL_Kiwi) discusses some things to know about INSTEAD OF triggers – from execution plans and worktables to a cardinality estimation bug in SQL 2014.
Aaron Bertrand (@AaronBertrand) follows up on a question from his triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.
After a discussion with a colleague, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a look at the IDENT_CURRENT() function, and demonstrates how it cannot be relied upon for reporting the IDENTITY value that was generated – even under the SERIALIZABLE isolation level.