Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Why should you use or avoid select * statements?
How to use linked server?
In which tcp/ip port does sql server run? Can it be changed?
What is a document index?
Explain why variables called the most powerful component of ssis?
What do you understand by the analysis services in sql server?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Explain transaction server implicit?
How efficient you are in oracle and SQL server?
How to connect of datebase with sql express.?
What is the use of =,==,=== operators?
explain extended properties
Describe how to use the linked server?
How secure is sql server database?
What is triggers and stored procedures?
