SQL Server Triggers Pros and Cons
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-06-05
Triggers
SQL Server Triggers Pros and Cons
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-05-29
SQL Server Trigger on View Example
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
2019-05-01
Learning about DML Triggers
Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.
2019-02-19
2,968 reads
Triggers: Threat or Menace?
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
2016-10-20
1,136 reads
List Out All User Defined Triggers
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2019-05-03 (first published: 2015-07-07)
842 reads
2014-05-05
1,742 reads
2014-04-02
2,215 reads
2013-09-10
2,235 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers