RE: Oracle vs sybase

From: <ryan_gaffuri_at_comcast.net>
Date: Tue, 17 Apr 2007 20:45:17 +0000
Message-Id: <041720072045.10085.462531DD00024340000027652200748184079D9A00000E09A1020E979D@comcast.net>

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>

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

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 17 2007 - 15:45:17 CDT