Using NOLOCK and READPAST table hints in SQL Server

Tuesday May 22nd 2007 by DatabaseJournal.com Staff

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the 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

Mobile Site | Full Site