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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is a NOLOCK?

Question Posted / latha sree

Answers were Sorted based on User's Feedback



What is a NOLOCK?..

Answer / michael

Advantage:
applying nolock in select statement will increase
concurreny and performance in fetching.

Disadvantage:
it does'nt consider the transaction scenario, even if the
transaction is under process not yet commited or rollback
it will fetch the current record
eg

begin tran
insert into tablename
values('1','asdf')

select * from tablename with (nolock)

-- it will display the table with inserted record.
but the transaction is not completed, it can be rollback
so it became dirty read.

Is This Answer Correct ?    28 Yes 2 No

What is a NOLOCK?..

Answer / naren

Using NOLOCK politely asks SQL Server to ignore locks and
read directly from the tables. This means you completely
circumvent the lock system, which is a major performance
and scalability improvement. However, you also completely
circumvent the lock system, which means your code is living
dangerously. You might read the not-necessarily-valid
uncommitted modifications of a running transaction. This is
a calculated risk.

Is This Answer Correct ?    19 Yes 1 No

What is a NOLOCK?..

Answer / 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

More SQL Server Interview Questions

What are the ways available in sql server to execute sql statements?

0 Answers  

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

0 Answers   Infosys,

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

What is self contained multi valued query?

0 Answers  

What is right outer join in sql server joins?

0 Answers  

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

Explain different types of lock modes in sql server 2000?

0 Answers  

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

What is dbcc command in sql server?

0 Answers  

Explain how to maintain a fill factor in existing indexes?

0 Answers  

What is transaction server distributed transaction?

0 Answers  

How can you find out which stored procedures are recompiling?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories