New Index Locking Granularity in SQL Server 2005 Gives You More Options

(Brad M. McGehee) While most DBAs are familiar with how locking works with tables, few DBAs are familiar with how SQL Server 2005 applies locking to indexes. That’s right, indexes, just like tables, are subject to locking. And as most DBAs already know, inappropriate locking (in tables or indexes) c

Read More - Register for Free Membership