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 retrieve field names from the table in SQL through JAVA code?
Explain the difference between functions and stored procedures in sql server?
What are the different types of columns types constraints in the sql server?
Do you know what is lock escalation?
What kind of problems occurs if we do not implement proper locking strategy?
Describe how to use linked server?
What is the difference between sdf and mdf?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What do you mean by acid?
How to rebuild the master database?
What is store procedure?
Describe triggers features and limitations?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Will sql server 2005 allow you to reduce the size of a column?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
