Re: Why a DELETE transaction running in read-uncomitted is acquiring a

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
Date: Mon, 4 May 2009 16:56:01 -0400

A DELETE never happens in Read-Uncommited mode regardless of what hint you may tried to use. Any modifications MUST take some sort of lock.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"C elek" <C elek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F39FABDC-857D-4E2E-980B-F2E1C7E553D4@xxxxxxxxxxxxxxxx

I am having trouble to conceptually understand this. COuld someone point me
to the RTFM or link ?

Follow-Ups:
- Re: Why a DELETE transaction running in read-uncomitted is acquiri
  - From: C elek

References:
- Why a DELETE transaction running in read-uncomitted is acquiring a
  - From: C elek

Prev by Date: Re: Shrinking Log Files - How important?
Next by Date: SQL Server 2005 Installation Procedures w\SQL Server 2000
Previous by thread: Why a DELETE transaction running in read-uncomitted is acquiring a
Next by thread: Re: Why a DELETE transaction running in read-uncomitted is acquiri
Index(es):
- Date
- Thread

Relevant Pages

Re: Plaza Balconies
... Otherwise, and there are no signs, you may park on some other level, take the elevator down to casino, walk through entire casino to where the front desk used to be, to find out it is the slot club booth now, walk to elevators, go to third floor, walk down hall past hotel rooms, then more walking to registration. ... When I stayed there 10 years ago, I was able to jimmy the lock and get out on the balcony. ... Andrew <-- is it JUNE yet? ...
(alt.vacation.las-vegas)
Losing friends/Luck of the draw-- Long
... We used to work together at a movie theater in Georgetown, Washington, D.C., ... The employee's handbook Andrew wrote for the theater contained this ... He left them there as a sort of a shrine. ... Sad and horrifying... ...
(alt.support.stop-smoking)
Re: Losing friends/Luck of the draw-- Long
... always thought of Andrew on my birthday. ... We used to work together at a movie theater in Georgetown, Washington, D.C., ... He left them there as a sort of a shrine. ... Sad and horrifying... ...
(alt.support.stop-smoking)
Re: Switching TestSetPageLocked to trylock_page
... On Tuesday 05 August 2008 13:57, Andrew Morton wrote: ... Using the lock semantics bitops is the first one. ... This patch wouldn't do anything to ensure that callers get the review ...
(Linux-Kernel)
Re: Lock on WHERE clause, possible?
... > hint, I can do the SELECT on the data i'd like to be locked. ... > that they lock entire table from SELECTING. ... > I'm designing a continious FIFO sotck behaviour. ... > I call the UDF, it gives me available documents, and then I use ...
(microsoft.public.sqlserver.programming)