http://www.sqlservercentral.com/Content tagged Triggers posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)http://www.sqlservercentral.com/questions/Triggers/62673/2008/04/29http://www.sqlservercentral.com/questions/Triggers/62673/If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this. http://www.sqlservercentral.com/articles/Triggers/2747/2007/12/28http://www.sqlservercentral.com/articles/Triggers/2747/http://www.sqlservercentral.com/questions/Triggers/61589/2007/12/12http://www.sqlservercentral.com/questions/Triggers/61589/If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this. http://www.sqlservercentral.com/articles/Triggers/2747/2007/12/28http://www.sqlservercentral.com/articles/Triggers/2747/From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.http://www.sqlservercentral.com/articles/T-SQL/61483/2007/11/13http://www.sqlservercentral.com/articles/T-SQL/61483/http://www.sqlservercentral.com/questions/Triggers/61354/2007/10/22http://www.sqlservercentral.com/questions/Triggers/61354/If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this. http://www.sqlservercentral.com/articles/Triggers/2747/2007/12/28http://www.sqlservercentral.com/articles/Triggers/2747/In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required. http://www.sqlservercentral.com/redirect/articles/2509/2006/07/20http://www.sqlservercentral.com/redirect/articles/2509/Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/storedprocedurevstriggers/1449/2006/03/31http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/storedprocedurevstriggers/1449/Have you ever needed to audit your SQL Server 2000 database for changes to a table? A simple auditing solution is presented here by new author Tiago Silva using an INSTEAD OF trigger. http://www.sqlservercentral.com/articles/Triggers/triggersforauditing/2143/2005/11/29http://www.sqlservercentral.com/articles/Triggers/triggersforauditing/2143/This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000. http://www.sqlservercentral.com/articles/Triggers/triggersinsqlserver7.0and2000-what'snew/431/2005/06/24http://www.sqlservercentral.com/articles/Triggers/triggersinsqlserver7.0and2000-what'snew/431/This is a two part series on how triggers work in the two latest versions of MS SQL Server. Because there are some pretty significant additions in trigger functionality from 7.0 to 2000, we'll first need to look at what the two versions have in common. The second part to this series will look at the differences between the two MS SQL Server versions. http://www.sqlservercentral.com/articles/Triggers/triggers_1/389/2005/01/21http://www.sqlservercentral.com/articles/Triggers/triggers_1/389/Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/storedprocedurevstriggers/1449/2006/03/31http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/storedprocedurevstriggers/1449/Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This article continues the series and looks at an item I see mentioned in our discussion forum quite often, triggering external events. From a trigger. http://www.sqlservercentral.com/articles/Triggers/worstpracticetriggeringexternalevents/1283/2004/02/23http://www.sqlservercentral.com/articles/Triggers/worstpracticetriggeringexternalevents/1283/In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers. http://www.sqlservercentral.com/articles/Triggers/auditingtriggers/579/2004/01/16http://www.sqlservercentral.com/articles/Triggers/auditingtriggers/579/This articles covers a variety of techniques to let you bypass or conditionally execute code in a trigger based on criteria outside of the inserted/deleted tables. It also includes a contest that gives you a chance to win a copy of our book The Best of SQLServerCentral.com 2002! http://www.sqlservercentral.com/articles/Triggers/bypassingtriggers/1177/2003/11/24http://www.sqlservercentral.com/articles/Triggers/bypassingtriggers/1177/The columns_updated function gives you the ability to easily test to see if specific columns were modified with less code than you might otherwise need to use. In this article Andy Warren demonstrates how to create a trigger that uses this function and points out some reasons why you may NOT want to use it! http://www.sqlservercentral.com/articles/Triggers/triggerscolumnsupdated/115/2003/08/21http://www.sqlservercentral.com/articles/Triggers/triggerscolumnsupdated/115/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code. http://www.sqlservercentral.com/articles/Administering/sp_msforeachworker/711/2002/06/17http://www.sqlservercentral.com/articles/Administering/sp_msforeachworker/711/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000. http://www.sqlservercentral.com/articles/Triggers/triggersinsqlserver7.0and2000-what'snew/431/2005/06/24http://www.sqlservercentral.com/articles/Triggers/triggersinsqlserver7.0and2000-what'snew/431/This is a two part series on how triggers work in the two latest versions of MS SQL Server. Because there are some pretty significant additions in trigger functionality from 7.0 to 2000, we'll first need to look at what the two versions have in common. The second part to this series will look at the differences between the two MS SQL Server versions. http://www.sqlservercentral.com/articles/Triggers/triggers_1/389/2005/01/21http://www.sqlservercentral.com/articles/Triggers/triggers_1/389/In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000. http://www.sqlservercentral.com/redirect/articles/253/2001/07/27http://www.sqlservercentral.com/redirect/articles/253/