-
rmohan26 pointed out a problem about READERS waiting for WRITERS.
Those familiar with the topic can immediately tell how much performance, disk space and blocking issues depend on the chosen blocking model.
In particular, (unless anything changed about blocking model in SQL Server 7 compared to 6), SQL server had the problem of dead-locked readers.
While Oracle has the well known problem of "snapshot too old"( only a few authors managed to explain the whole problem in Oracle <9, may be things changed in 9i), it is still better than SQL Server's approach.
Another issue with SQL server 6 was missing documentation , e.g. for setting up just a simple read-only replication for large tables on slow network - in other words, the simplicity is OK untill a moment of truth comes.
Big advantage of SQL server against Oracle was a DDL generator for a database, with good and complete GUI - a big leap behind Oracle's exp utility or complex and buggy Designer.
-
Oracle x SQL Server
Not Oracle, neither SQL Server.
Dbase III Plus is the best !!!
-
Dbase III Plus is best for what?
