Triggers

Triggers: Threat or Menace?

  • Article

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger. Joe Celko describes a feature of SQL that 'gets complicated fast'.

2017-01-03

3,807 reads

Blogs

Creating a New Sequence–#SQLNewBlogger

By

I wrote about sequences in an editorial recently and decided to start using them....

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

How should I store currency values in SQL Server?

By

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...

Read the latest Blogs

Forums

Explanation of Page Splits

By stevec883

Q1 -- I have read quite a few articles on page splits and am...

(duplicate)

By stevec883

(sorry, this was a duplicate)

Script error

By sizal0234

I am trying to monitor the sql services on couple of instances and found...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers