When you define tables with foreign key constraints, SQL Server must check that the foreign key constraints will not be violated during DML operations.  If the foreign key columns are not indexed, there are two scenarios that will cause table locks to be placed on the foreign keyed table: During any delete operation During any […]