CATEGORIES
Acer
AMD
Apache
Apple
ASP
Business Object
Compaq
Crystal Reports
CSS
Database
Dell
DOT NET
Fujitsu
Gateway
Google
HP
HTML
IBM
IIS
Intel
Java
Mainframe
Microsoft
Networking
Oracle
SAP
SEO
Sony
SQL Server
Testing
Tomcat
Toshiba
Ubuntu
Visual Basic
Web Hosting
Windows
What is the use of nolock condition in SQL Query
Published by: Rinku (10/17/2008 7:29:10 PM)
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
- SQL Query to Copy and Insert a Record from Same Table
- 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 run my Stored Procedure in SQL Server 2005
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