Triggering my nerves…

Code Correctness, Reliability, SQL Server
This post is about something I come across more times than I would want to, and not even the least of people are repeatedly triggering my nerves with a thing like this.¬†Anyway, I expected you not to, when you are a database developer in a multinational software development company. Let's cut to the chase: this post is about triggers. Database triggers. Very handy database objects that can perform a lot of useful tasks for you whenever you modify data in a table. I'm kidding. Of course, triggers are handy, but they can cause issues for performance, deadlocking, concurrency, and can even bring a not-too-busy database to a grinding halt when they are used wrong. This post is not about that. A few weeks ago, I received a call from one…
Read More