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
How to truncate the log in sql server 2012? : sql server database administration
What is the difference between getdate and sysdatetime?
Write a query to find 5th highest amount paid from the customer table.
What is best institute to Learn DotNET And SQL in chennai?
What does <> symbol mean?
What does dml stand for?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is triggers and its types?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is exporting and importing utility?
What is difference between createstatement and preparedstatement?
Explain what is the difference between a local and a global temporary table?
Does sql server use t sql?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Can sql server 2016 run on windows 7?
