SQL Server 6.5 introduced row-level locking on inserts. SQL Server 7.0 supports full row-level locking for both data rows and index entries. Transactions can update individual records without blocking the pages. Many OLTP applications experience increased concurrency, especially when applications append rows to tables and indexes. The lock manager dynamically adjusts the resources it uses for larger databases, eliminating the need to adjust the locks’ server configuration option manually. The lock manager automatically chooses between page locking (preferable for table scans) and row-level locking (preferable for inserting, updating, and deleting data).