The points being made about the effect of FK of performance depending on the operation are valid. And the exists clause that article's first example shows as faster with the...

weitzera (10/21/2010)

---

The SQLCat team has published a top 10 list of best practices for building-a-large-scale-relational-data-warehouse in which they recommend against checking foreign keys on large fact tables. (recommendation 4, last...

This behavior of sql server of not checking fk constraints when re-enabling checking shows a woeful lack of concern for database integrity. It boggles the mind. Thanks for pointing it...