The Smart Guide to Building World-Class Applications
By Aviv Zucker, 10/22/2009
If you need to enforce business rules on multiple tables, try indexed views, which let you join tables and enforce uniqueness on the result set.