
	Home > SQL Server Tips > Database Management and Administration > Using Microsoft SQL Server triggers

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE MANAGEMENT AND ADMINISTRATION

Using Microsoft SQL Server triggers

Michelle Gutzait, Contributor
05.01.2006
Rating: -4.33- (out of 5)

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

One of my clients called me. The frantic communication went something like this:

I examined their database. Almost every table had at least one trigger attached to it. I tried to follow the logic of only one update, and I was terrified. It took me hours to understand the logic of this "spaghetti" database. At least the "recursive triggers" option was disabled. Imagine what could happen if it wasn't? I would have lost several more hours.

This is the ultimate dilemma: Should you use triggers in SQL Server? What are the implications? Will database triggers affect SQL Server performance and by how much? In this tip, I pinpoint some considerations for using triggers in SQL Server.

[IMAGE]
[IMAGE]Explore Microsoft SQL Server triggers
[IMAGE]
[IMAGE] Home Introduction
[IMAGE] Part 1 Why use triggers in SQL Server?
[IMAGE] Part 2 Designing and implementing triggers in SQL Server
[IMAGE] Part 3 Example: INSTEAD OF triggers vs. AFTER triggers
[IMAGE] Part 4 Example: One trigger vs. two for the same logic
[IMAGE] Part 5 Example: Nested triggers in SQL Server
[IMAGE] Part 6 Example: Heavy insertion process from OLTP and triggers
[IMAGE] Part 7 ...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server Performance Monitoring and Tuning
	Using traces in SQL Server Profiler
	SQL Server Mailbag: CALs, witnesses and unwanted changes
	SQL Server Mailbag: Data restoration and DB property management
	Working with IntelliSense in SQL Server 2008 Management Studio
	SQL Server Mailbag: Stored procedures, triggers and SSRS reports
	Troubleshooting Distributed Transaction Coordinator errors in SQL Server
	Clearing the Windows page file and its effect on server performance
	Optimizing SQL Server indexes –- even when they're not your indexes
	Performance implications of transaction log autogrowth in SQL Server
	The short course on how SQL Server really works

SQL/Transact SQL (T-SQL)

Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server

SQL language crash course (just enough to be dangerous)

Working with IntelliSense in SQL Server 2008 Management Studio

SQL Server Mailbag: Stored procedures, triggers and SSRS reports

Working with sparse columns in SQL Server 2008

Determining the source of full transaction logs in SQL Server

New GROUP BY option provides better data control in SQL Server 2008

Using the OPENROWSET function in SQL Server

Loading data files with SQL Server's BULK INSERT statement

Importing and exporting bulk data with SQL Server's bcp utility

SQL/Transact SQL (T-SQL) Research

SQL Server Stored Procedures

SQL Server Mailbag: CALs, witnesses and unwanted changes

SQL Server Mailbag: Stored procedures, triggers and SSRS reports

Top tips and tricks for SQL Server database development

Top 10 SQL Server development tips of 2008

SQL Server trigger vs. stored procedure to receive data notification

SQL Server errors, failures and other problems fixed from the trenches

SQL Server and data manipulation in T-SQL

How to use SQL Server 2008 hierarchyid data type

SQL Server stored procedures tutorial: Write, tune and get examples

Check SQL Server database and log file size with this stored procedure

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

contiguity (SearchSQLServer.com)

contiguous (SearchSQLServer.com)

drilldown (SearchSQLServer.com)

hashing (SearchSQLServer.com)

hybrid online analytical processing (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Example: Cursors in SQL Server triggers

ABOUT THE AUTHOR:

[IMAGE]Michelle Gutzait works as a team member of the SQL Server Database Experts at www.pythian.com, a worldwide company providing Remote Administration services for databases, operating systems, SANs and networks. Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant. For the past 10 years, she has worked exclusively with SQL Server. Her skills include SQL infrastructure and database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS/SSIS packages, administrative and infrastructure tools development, reporting services and more.

Rate this Tip

To rate tips, you must be a member of SearchSQLServer.com.
Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SQL Server Development - .NET, C#, T-SQL, Visual Basic

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy