Community

SQL Server UPDATE lock and UPDLOCK Table Hints

(Sergey Gigoyan) In SQL Server databases with actively running transactions, it is a common situation when more than one transaction tries to modify the same data simultaneously. In such instances, SQL Server deadlocks are often quite possible, which can be a real issue in terms of performance.