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
What is policy based management (pbm)? : sql server database administration
List some advantages and disadvantages of stored procedure?
What do you understand by sql server agent?
What is sql server management studio? : sql server management studio
What is forward - only cursors / read only cursor?
Explain rdbms?
What are the 7 disadvantages to a manual system?
Explain about thread and memory management process of SQL?
Is sql server free?
How many ways to create table-valued functions?
Different types of keys in SQL?
What is normalization of database?
What is the default server name for sql server?
What is the synonym of join?
What does <> symbol mean?
