-
Blocked/Blocking V.2
Where do I put the NOLOCK?
Thanks!
------------
colin Leversuch-Roberts at 12/8/99 6:50:27 AM
Consider using NOLOCK ( bearing in mind the implications of .. ) in your query
It's a technique that can minimise locking for complex reports.
------------
Andrew Wiegand at 12/7/99 10:24:19 PM
yes,
The query trying to update/insert records into the table must wait for the other query to finish before it can acquire the appropriate locks on the table.
------------
White Choco at 12/7/99 7:21:56 PM
Hello...
Is it normal in SQL Server 6.5 the user who only running the query blocking the other user who try to update/add the records?
note: The query is a complex SQL.
Many Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|