MS SQL Server
MS SQL Server can lock at table, page, and row level.
Uses intention read (“share”) and intention write (“exclusive”) locks at the table and page level.
Tries to avoid escalation by choosing the “appropriate” granularity when the scan is instantiated.