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'.


3,807 reads


Cool Stuff in Snowflake – Part 9: ILIKE


I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...

Scalar Valued Functions in SQL Server 2019


(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs


Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Query web API and return JSON data

By jim.powers

Hello, We use a service that provides an API for pulling our real-time data....

Linked Table To MS Access error

By mjdemaris

Hello All, I have one table that is giving me problems. Access is the...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers