Re: Oracle out the door
Date: Wed, 30 Apr 2008 23:06:46 +0300
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.