
	Home > SQL Server Tips > Database Administration > Optimize database triggers in SQL Server 2000

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE ADMINISTRATION

Optimize database triggers in SQL Server 2000

Michelle Gutzait, Contributor
05.01.2006
Rating: -4.00- (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:

"Our applications started to do crazy things in the database," said the client. "We don't understand what is happening. New rows are added to one table and another table is changed. We successfully update a row, and when we refresh the application form, different data appears. Also, it takes too long to update a single row. Is it a virus? Can it be that SQL Server has a bug in it?"

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

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server Performance Monitoring and Tuning
	Performance implications of transaction log autogrowth in SQL Server
	The short course on how SQL Server really works
	Determining the source of full transaction logs in SQL Server
	Improving SQL Server full-text search performance
	New GROUP BY option provides better data control in SQL Server 2008
	Microsoft SQL Server 2008 Resource Governor primer
	Examining data files when SQL Server tempdb is full
	Testing transaction log autogrowth behavior in SQL Server
	Meeting business needs with SQL Server full-text search
	Using dynamic management views to improve SQL Server index effectiveness

SQL/Transact SQL (T-SQL)

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

Testing transaction log autogrowth behavior in SQL Server

Securing SQL Server with access control, login monitoring and DDL triggers

Top 10 SQL Server development tips of 2008

The sqlcmd utility in SQL Server

SQL/Transact SQL (T-SQL) Research

SQL Server Stored Procedures

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

SQL Server source code analysis and management adds database security

Configure SQL Server Service Broker for sending stored procedure data

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

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 have triggers or should you not? What are the implications? Will triggers affect performance and by how much? In this tip, I pinpoint some considerations for using triggers and specifically focus on performance.

[TABLE]

More from SearchSQLServer.com

Ask the Experts: DDL vs. DML triggers

SQL Server Clinic: T-SQL performance problems and solutions

Topic: Look up additional stored procedures and development tips

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