Re: Oracle 8i or 9i vs SQL Server

On Wed, 17 Jul 2002, Richard Foote wrote:

> I *DON'T* want to start another war over this (Oracle is better, no it's not
> SQL Server can do that just as well, rant rant rant). I also appreciate
> they're not exactly apples and apples (and that's probably why I haven't
> found quite what I'm after).
> Any help would be muchly appreciated.

Two pieces of advice:

1. linux.sybase.com. For a small database that doesn't need the newest features, Sybase offers the 11.0.3.3 server for Linux *FOR FREE*, and it's equivalent to SQL Server 6.5 if you configure it to listen at port 1433. Find basic instructions for configuring it in the Linux book on my website.

   Why anybody pays for SQL Server I'll never know.

2. As Tom Kyte has told us, Oracle allows unlimited row locks and *never*

   escalates a lock. SQL Server has a limited, RAM-based set of row locks    and will escalate row locks to a table lock. Guess which approach    supports more users.

   / Charles J. Fisher              | "A fanatic is one who can't change his /
  /  cfisher_at_rhadmin.org            |  mind and won't change the subject."  /
 /   http://rhadmin.org             |                 -- Winston Churchill /
---------------------------------------------------------------------------