Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle vs sybase

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.

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?  

<!--

 /* 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US