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
Define self join in sql server joins?
Explain what are the different index configurations a table can have?
What is the maximum size of a row in sql server?
Explain trigger and trigger types?
How do I find the sql server version?
What is a recursive stored procedure in sql server?
Explain error handling in ssis?
How do you handle datasets larger than 50 gb?
Why do we use trigger?
What is a fill factor?
What is triggers in ms sql server?
What are the different types of backups avaialabe in sql server 2005?
What do you understand by triggers and mention the different types of it?
How do you create type- insensitive operator?
What is the purpose of linked server configuration in sql server?
