Using NOLOCK and READPAST table hints in SQL Server

[From Builder.com]

When data in a database is read or modified, the database engine uses special types of controls, called locks, to maintain integrity in the database. Locks basically work by making sure database records involved in a transaction cannot be modified by other transactions until the first transaction has committed, ensuring database consistency.

The article continues at

http://builder.com.com/5100-6388_14-6185492.html?tag=sc

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles