http://www.sqlservercentral.com/Content tagged Triggers, T-SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints.http://www.sqlservercentral.com/redirect/articles/63705/2008/07/23http://www.sqlservercentral.com/redirect/articles/63705/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/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/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/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/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/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/