Re: Oracle versus Sqlserver

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 17 Jan 2002 09:23:49 GMT
Message-ID: <3c4697e8.2754339@news-vip.optusnet.com.au>

Keith Boulton doodled thusly:

>> SQL Server has no multi-version consistency model which means that
>"writers
>> block readers and readers block writers" to ensure data integrity. In
>> contrast, with Oracle the rule is "readers dont block writers and writers
>But sql server is considerably faster and in most cases you can design
>around this issue just like you can design around "snapshot too old"
>

oh no, you can NOT "design around it"!!!

Not without losing some serious functionality.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Jan 17 2002 - 03:23:49 CST