Does SQL Server make locks at row level?

Filed under: Database Design, I'm a Newbie, SQL Server 2005 — SQL Stan at 4:51 pm on Tuesday, August 28, 2007

Q:  Is it true that SQL Server 2005 doesn’t make locks at row level and only makes page-level locks?

Iain Kick says:   No, SQL Server can create locks at the row level and escalate to page, extent, table and database level as neccessary. More details on SQL Server locking can be found at sql-server-performance.com.

Technorati Tags:
, , , ,

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>