T-SQL Tuesday #106 – Trigger Headaches or Happiness

Posted on September 3, 2018 by way0utwest

tsqltuesdaySince I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield.

Triggers, for fun and frustration

I’ve been working with SQL Server and T-SQL a long time, and across many jobs, I think I’ve ended up using triggers in 0.01% of my tables or less. They can be a useful and helpful construct, but they can also be problematic and difficult, especially in the age of changing business models and rules.

Since I’ve found triggers to be both helpful and hurtful, I decided to ask you to write about an experience you’ve had with triggers. Either good or bad, but let me know this month what stands out in your mind.

The Rules

As always, the rules for this month are simple.

  • Write and publish a post on September 11, 2018, UTC time.
  • Include the T-SQL Tuesday logo (you can grab this above) and link your post back to this invitation.
  • Leave a comment/pingback on this post for me to use to include you in the roundup
  • Have fun.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

37 Responses to T-SQL Tuesday #106 – Trigger Headaches or Happiness

  1. Pingback: T-SQL Tuesday #106 – Trigger Headaches or Happiness – T-SQL Tuesday

  2. Pingback: Why I Love DML Triggers in SQL Server - by Kendra Little

  5. Pingback: Triggers – good or bad? - LobsterPot Blogs

  6. Pingback: T-SQL Tuesday #106 Trigger headaches or happiness? - Jon Shaulis DBA

  8. Pingback: Faking Temporal Tables with Triggers – SQL with Bert

  11. Pingback: TSQL Tuesday 106 – Trigger Headaches or Happiness: Capturing Database Creations. – No Column Name

  13. Pingback: A Tale of a Trigger | Bob Pusateri - SQL Server and Kindred Subjects

  15. Pingback: TSQL Tuesday #106: Triggers and the Spiral To Oblivion – SQL Undercover

  17. Pingback: What happens in a trigger stays in the transaction: T-SQL Tuesday #106 | SQL Studies

  19. Pingback: The Helpful Triggers | Voice of the DBA

  22. paschott says:
    September 11, 2018 at 9:00 am

    Fun topic that’s near and dear to all of us. I decided to write about “disabling” triggers.
    https://schottsql.wordpress.com/2018/09/11/disabling-triggers-without-alters/

    Like

  23. Pingback: T-SQL Tuesday #106 | downshiftdata

  25. Pingback: T-SQL Tuesday #106: How to use triggers and not be sad - SQL Server Fast

  30. Pingback: TSQL Tuesday: Who is on my server? | SQLGene – Learning SQL Slowly

  32. Pingback: T-SQL Tuesday 106: 5 Things Not to Do With Triggers – nate_the_dba

  33. natethedba says:
    September 11, 2018 at 11:33 pm

    I love it when a postback works the first time. =D

    Like

  34. Pingback: T-SQL Tuesday #106 – The Trouble with Triggers | Matthew McGiffen DBA

  35. Matthew McGiffen says:
    September 12, 2018 at 1:44 am

    Hopefully I’m in just under the wire – I believe it’s still Tuesday somewhere!
    https://matthewmcgiffen.com/2018/09/12/t-sql-tuesday-106-the-trouble-with-triggers/

    Like

  36. Pingback: The Trigger Roundup–T-SQL Tuesday #106 | Voice of the DBA

Comments are closed.