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 do I view views in sql server?

1010


What is a cube? : sql server analysis services, ssas

1000


What will be query used to get the list of triggers in a database?

1005


Does index speed up select statements?

1012


query processing

2175


What are different types of constraints?

923


How to use copy and concatenate commands in SQL?

1143


Difference between connected and disconnected database in .net with sql server?

1097


How do you start single user mode in clustered installations?

941


How to create nested stored procedure?

1020


What is function of CUBE ?

1047


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1683


Do you know the capabilities of cursors?

1150


Can we add our custom code in ssis?

988


Explain what is use of dbcc commands?

1059