(See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx) The optimizer is a pretty smart little animal. It can even use constraints to eliminate some data access or part of a query. That assumes however that the constraint is trusted. For example, for ...

Also see Idera's hilarious new video! ''Life of Simon, SQL Server DBA'' http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...(read more)