Re: Oracle vs sybase
- From: Phil Singer <psinger1@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Apr 2007 22:02:28 -0400
ryan_gaffuri@xxxxxxxxxxx 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
