Re: Oracle vs sybase

From: Phil Singer <psinger1_at_chartermi.net>
Date: Thu, 19 Apr 2007 20:57:15 -0400
Message-ID: <462970B4.3000401@chartermi.net>

ryan_gaffuri_at_comcast.net wrote:
> 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?
>
>

I would love to read a discussion of this by someone who really understands Oracle and SQL Server 2005. What I have read is strictly from the MSFT camp, and it is obvious that whoever wrote it did not understand Oracle.

What little I know: SQL Server 2005 has something analogous to Oracle's UNDO. It is not turned on by default. It works in a similar manner (but the devil is in the details!). Using it appears to exact some performance penalties.

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

Received on Thu Apr 19 2007 - 19:57:15 CDT