Triggers

External Article

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

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Restart SSA in a job?

By jbalbo

Hi, I have a job that rebuilds indexes after a refresh of a replicated...

Intermittent sqlmail success - troubleshooting

By brambor

Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5103.6 (X64) SQLMail Account configured with SSL...

T-SQL help

By leo_dec

I need help to write the T-SQL with scenario that if room got multiple...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers