Exploring SQL Server Triggers John Papa explores the different trigger types that SQL Server 2000 makes available and discusses how triggers can be implemented to enforce business rules or referential data integrity in database applications.
INSTEAD OF Triggers Kalen Delaney explains the INSTEAD OF trigger type introduced in SQL Server 2000.
Use Triggers to Set Limits Tom Moreau leads an exercise in building a trigger to limit the number of detail rows for an order to a maximum of four, providing a great step-by-step analysis of the problem and the T-SQL tweaks that are needed to get it right.
No Table? No Problem If you've solved T-SQL problems by using an iterative or set-based approach involving tables, Itzik Ben-Gan shows you how you can increase performance with a nontable, single-expression approach.
Changing Times Learn some basic steps for simplifying calculations based on dates and times.
Grouping Time Intervals Itzik Ben-Gan shows you an elegant solution for selecting groups of data based on overlapping time intervals.