Re: Oracle out the door
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 30 Apr 2008 23:06:46 +0300
Message-ID: <6e49b6d00804301306o1651b339ldc870f3ac3a49696@mail.gmail.com>
Date: Wed, 30 Apr 2008 23:06:46 +0300
Message-ID: <6e49b6d00804301306o1651b339ldc870f3ac3a49696@mail.gmail.com>
2008/4/30, Jared Still <jkstill_at_gmail.com>:
> Due to SQL Server being unable to do consistent reads.
> Just had this conversation with a (very good) developer the other day.
> He was quite surprised that no temp tables were required in Oracle
> for the purpose of providing a consistent view of the data.
What version is he using? SQL Server 2005 has new isolation level snapshot isolation that more or less deals with that. AFAIK it works e.g. resolved one of our apps deadlocking problem on quite highly volatile table.
Gints Plivna
http://www.gplivna.eu
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 30 2008 - 15:06:46 CDT