Customizing Locking and Row Versioning

Customizing Locking and Row Versioning

SQL Server 2008 R2

Applications using the Microsoft SQL Server Database Engine can alter the default locking and row versioning.



Customizing the Lock Time-Out

Handling time-outs and setting the lock time-out duration.

Customizing Transaction Isolation Level

Setting the transaction isolation level.

Locking Hints

Using table-level locking hints with the SELECT, INSERT, UPDATE, and DELETE statements.

Customizing Locking for an Index

Configuring the locking granularity for an index.

Community Additions

© 2016 Microsoft