Tag : triggers - SentryOne Team Blog

Tag: triggers

T-SQL Tuesday #106 : INSTEAD OF triggers

T-SQL Tuesday #106 : INSTEAD OF triggers

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.

Follow-up #1 on leading wildcard seeks

Follow-up #1 on leading wildcard seeks

Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

Paul White : Interesting things about INSTEAD OF 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 : T-SQL Tuesday #64 : One Trigger or Many?

Aaron Bertrand (@AaronBertrand) follows up on a question from his triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.