What is a NOLOCK?

Answer Posted / guest

Do not issue shared locks and do not honor exclusive locks.
When this option is in effect, it is possible to read an
uncommitted transaction or a set of pages that are rolled
back in the middle of a read. Dirty reads are possible. Only
applies to the SELECT statement.

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What guidelines should be followed to help minimize deadlocks?

507


What are the new security features added in sql server 2012? : sql server security

535


What is xdr?

567


Tell me what are cursors and when they are useful?

511


What is microsoft sql server?

542






How to download and install sql server 2005 books online?

541


What is equi join with example?

555


Tell me can we use custom code in ssrs?

601


How to loop through returning rows?

576


How can you append an identity column to a temporary table?

451


Can an entity have two primary keys?

529


What is the difference between seek predicate and predicate?

584


Your table has a large character field there are queries that use this field in their search clause what should you do?

505


What is self contained sub query?

559


How to get the definition of a trigger back?

551