Tag : triggers - SentryOne Team Blog

Tag: 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.