CATEGORIES
What is the use of nolock condition in SQL Query
Published by: Rinku (10/17/2008 7:29:10 PM)
OCT 17 2008
I am instructed by my DBA to use : with (nolock) indicator whenever i create joins on many tables. I dont really understand the need for the nolock criteria. The results of the query and the execution time is the same with or without the - with (nolock) indicator. So why use it. Can someone explain
Most Popular Articles
- How can I run my Stored Procedure in SQL Server 2005
- SQL Join Query for Microsoft Access Database
- What is the use of nolock condition in SQL Query
- when to use cast and when to use convert operator in SQL
- How can I Truncate my Database Log to Reduce the Size
when to use cast and when to use convert operator in SQL >>
<< How Can I Repair or Compact an MS Access Database in ASP
COMMENT
Name: samir kazi
when we fire a query on a table the query results a lock on a data in a table and if sum other user tries to retrieve the same data it doesnt works..so firing a query with nolock results in making that or u can say row unlock so that other user can also access the same data at same time