Bookmark : Check & Foreign Key constraint Improves Query Performance

Obvious after some background reading on the query optimiser, but today's SSC post does a great job of showing the effect of Foreign Key Constraints on Query Performance.