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 a functions and types in sql server?
What is the difference between ddl,dml and dcl commands?
Explain different types of self contained sub query?
What is a group function explain with an example?
What are the different types of sql server replication? : sql server replication
How to retrieve field values using mssql_result()?
How to read data in a table with "select" statements?
What is raid, and how it can influence database performance?
Can group by and orderby be used together?
What are sub reports and how to create them?
What is join and name different type of joins?
Explain about merge replications?
What is view in sql?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Define left outer join in sql server joins?