If you need to implement cascading referential integrity (such as cascading deletes) in your SQL databases, use the cascading referential integrity constraint instead of triggers to perform the cascading ... [Read Full Article]

http://www.sql-server-performance.com/tips/trigger_tuning_p1.aspx