No mention of trusted FK's? See http://sqlblog.com/blogs/hugo_kornelis/archive/2007/03/29/can-you-trust-your-constraints.aspx Handy to know, especially if you are lumbered with a db that exposes all data through very complex (and poorly performing )views!