Re: Row Level Locking
Date: 1996/10/16
Message-ID: <5427dr$p9_at_inet-nntp-gw-1.us.oracle.com>#1/1
Mark Galloway <mark.galloway_at_lawson.com> wrote:
>Can someone educate me on the support that MS SQL Server has or doesn't
>have for row-level locking?
Microsoft SQL-Server 6.5 locks at the record or row-level on INSERTS only. Even then, by default it still locks INSERTS at the page level. SELECTS, UPDATES, and DELETES are all locked at the page level (at the lowest). It should be mentioned that SQL-Server also escalates locks to page, pages, table, and possibly even multiple tables level - they call it "dynamic escalation" - everyone eles calls it more programming and contention!
For a good example of what this means to a customer of Microsoft SQL-Server please see what Communications Week (www.commweek.com) reported in their September 16, 1996 issue - "Developers Search for Answers at Microsoft SQL Server Conference". They refer to this row-level locking and what the developers and users have to say about Microsoft SQL-Server - NOT HAPPY! Received on Wed Oct 16 1996 - 00:00:00 CEST