Re: Oracle vs sybase

From: Naqi Mirza <naqimirza_at_yahoo.com>
Date: Tue, 17 Apr 2007 14:25:22 -0700 (PDT)
Message-ID: <911401.46374.qm@web32401.mail.mud.yahoo.com>

if i remember correctly its called snapshot isolation - its not on by default, though.

Original Message ---- From: "ryan_gaffuri_at_comcast.net" <ryan_gaffuri_at_comcast.net> To: oracle-l_at_freelists.org Sent: Wednesday, 18 April, 2007 1:45:17 AM Subject: RE: Oracle vs sybase

I met a SQL Server DBA who told me that SQL Server 2005 has something akin to multi-versioning. Does anyone know anything about this? My understanding is that reads no longer block writes. is this true?

Original message -------------- From: "Kevin Closson" <kevinc_at_polyserve.com>

<!--

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";} a:link, span.MsoHyperlink

{color:blue;text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed

{color:purple;text-decoration:underline;} span.EmailStyle17

{font-family:Arial;color:navy;}
_filtered {margin:1.0in 1.25in 1.0in 1.25in;} div.Section1

{}
-->

If MSFT is being honest, they claim there is no remaining Sybase code in SQL Server 2005. FWIW.

There may not be anything recent on Sybase, but maybe if you searched for comparisons between Oracle and MS SQL Server you might have better luck. MS SQL is based on an earlier version of Sybase, but I believe that since then, both have independently added row-level locking, which Oracle had long ago.

Dennis Williams

Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 17 2007 - 16:25:22 CDT