wow, great tip, great write-up.

I ran this statement against a live, production database

select name,is_not_trusted from sys.foreign_keys

and it returned 57 untrusted foreign keys! Looks like I'll be making a script to automaticallly scan for, and update these constraints.

This article has opened up to me a whole new level of understanding query performance and internal database politics.

Many thanks,

Rod