Re: blocking caused from SQL with (nolock) hint
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 12/07/04
- Next message: Dan B: "Re: Data Loss?"
- Previous message: Simon Shearn: "Re: Data Loss?"
- In reply to: Jay P: "blocking caused from SQL with (nolock) hint"
- Next in thread: Jay P: "Re: blocking caused from SQL with (nolock) hint"
- Reply: Jay P: "Re: blocking caused from SQL with (nolock) hint"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Dec 2004 15:17:47 -0500
Jay,
No more information (environment, SQL code, etc) than the question, means
this question is hard to answer.
(1) If your SQL is doing an update, then (of course) it will lock the
resources being updated.
(2) I have also seen a repeated instance of an older version of Access
causing a lock (a SCH-M lock) even though it had no rights to make any
schema change.
Post some more details if you have them.
RLF
"Jay P" <Jay P@discussions.microsoft.com> wrote in message
news:C20A1880-D3EC-498E-B6E1-93F3D79FCA87@microsoft.com...
> I am seeing blocking in a database that is caused by a SQL statement that
> joins two tables with (nolock) hints. How is that possible? I thought
> nolock would perform a dirty read and would not block readers. Is that
not
> the case?
>
> Thanks,
> Jay
- Next message: Dan B: "Re: Data Loss?"
- Previous message: Simon Shearn: "Re: Data Loss?"
- In reply to: Jay P: "blocking caused from SQL with (nolock) hint"
- Next in thread: Jay P: "Re: blocking caused from SQL with (nolock) hint"
- Reply: Jay P: "Re: blocking caused from SQL with (nolock) hint"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
