pete lai

A member of the Philip Greenspun's Homepage community since June 8, 2005

If you were to log in, you'd be able to get more information on your fellow community member.

June 8, 2005, on Database Management Systems:
Phil is somewhat incorrect about vendors supporting row-level locking support. MS has supported row-level locking since SQL Server 7.0. In practice, its transaction manager decides how granular a lock will be according to the parameters of the query. If too many individual rows are going to be locked in a transaction (according to some calculated "lock escalation threshold"), the entire table will be locked.