It is always more efficient to maintain referential integrity by using constraints rather than triggers. Sometimes it isn't obvious how to do this. Until a recent idea by Alex Kuznetsov, the history table presented problems for checking data that were difficult to solve with constraints. Joe Celko explains. Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.