• Can you explain why there will be a deadlocks when SQL Server doesn't perform a lock escalation even when the batch size is high?

    Each process will lock different sets of key(rows) , I don't understand how deadlock could happen.

    Thanks