Topic: DELETE leads DEADLOCK
DELETE FROM MyTable WHERE ID = @ID
to DEADLOCK, because locks to [b X. [/b]
The matter is that system so that parallely a heap similar DELETE commands and they "" with each other for the same table.
1. What <censored> is locked all table, instead of a line if search goes on a key (clustered index)?
2. How it to force without rewriting request to fulfill ROW_LOCK?