Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How can you list all the table constraints in a database?

985


Can two tables share the same primary key?

987


SQL Server Architecture ?

2523


What are the purposes of floor and sign functions?

1020


What is the difference between lock, block and deadlock? : sql server database administration

1094


Why do you need a sql server?

1173


What are rest-style architecture's?

172


What does man by sql wildcard characters in sql server?

1106


What is SubQuery in SQL Server 2008

1075


Sql server reporting services vs. Crystal reports.

140


How would you add a section to a table?

1112


What is report snapshot?

163


What is a trigger? Why we need it?

1058


What are relationships and mention different types of relationships in the dbms

1013


Write an sql query to find first weekday of the month?

977