Questions tagged [locking]
46 questions
0
votes
0 answers
SQL Server: Are shared locks used for foreign key constraint enforcement, and how long are they kept?
Main question is in the subject.
In more detail: Let's say we have a table T with a FK constraint to table U (for simplicity, to its PK, and both table use clustered indices on their PKs). Now, we INSERT or UPDATE a row in T, thereby writing the FK…
![](../../users/profiles/577257.webp)
H.M. Müller
- 1
- 2