Re: Isolation levels

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Tue, 15 May 2007 15:41:33 -0300
Message-ID: <4649fe98$0$4033$9a566e8b@news.aliant.net>

Razvan Socol wrote:
> Please read the following posts by Craig Freedman, member of the SQL
> Server query execution team:
> http://blogs.msdn.com/craigfr/archive/2007/04/25/read-committed-isolation-level.aspx
> http://blogs.msdn.com/craigfr/archive/2007/05/02/query-plans-and-read-committed-isolation-level.aspx
> http://blogs.msdn.com/craigfr/archive/2007/05/09/repeatable-read-isolation-level.aspx
>
> Is the behaviour described in these posts the *correct* behaviour, as
> defined by ANSI SQL standards, considering the Read Committed and
> Repetable Read isolation levels, respectively ? Do other DBMS-s behave
> the same way ? I am aware that the behaviour would be different if we
> use snapshot isolation, but I'm interested how things *should* work
> without snapshot isolation.
>
> I'd like some responses from people who know really well the ANSI SQL
> standard and the isolation levels defined in it.

Thinking you might get a better response from comp.databases, I am cross-posting your question there. Received on Tue May 15 2007 - 13:41:33 CDT