Community

SQL Server Performance Testing for Check Constraint vs Foreign Key

(Ben Snaidero) In my never ending quest of improving SQL Server database performance I often think about how foreign key constraints can slow down insert performance. While everyone understands why foreign key constraints are required, to protect referential integrity, what if there was some other