T-SQL Tuesday #106 – Trigger Headaches or Happiness

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

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

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

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

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

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

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

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

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

  11. paschott says:

    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/

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

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

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

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

  16. natethedba says:

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

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

  18. Matthew McGiffen says:

    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/

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.