Re: Oracle vs. SQL server

You are correct that people almost always favor the product that they know best and work with. But I wouldn't ding SQL Server based on your perceptions. Were I to ding it I would do so based on the fact that it has no substitute for multiversioning, its locking architecture is inadequate, and both its security and scalability insufficiet for systems involving large amounts of data (hundreds of gigabytes to terabytes) and large numbers of users (and large doesn't mean hundreds).

There is a reason why most of the people here in the Seattle-Redmond area that have left Microsoft and founded their own companies didn't choose SQL Server as their database: They know its limitations. And that includes some of the team members that developed SQL Server's engine.

Daniel Morgan

Joe Yong wrote:

> You're wasting your time asking here or the sqlserver newsgroup (if
> you did). Go do a Google search for your answers.
>
> 99% of the people here will tell you oracle rules and 99% of the folks
> in the sqlserver newsgroup will tell you sqlserver rules. I've worked
> with both (and a bunch of other less popular ones) and still do. IMHO,
> oracle no longer has as clear an advantage as it used to.
>
> btw, anyone who dings sqlserver as being buggy compared to oracle is
> either on crack, drunk or just a bigot (or all of the above). There's
> no such thing as bugfree software unless you count hello world apps
> (and even that has no guarantees). I've had to deal with more bugs
> than new orleans in july with oracle databases (thankfully, i don't
> manage the apps) and the same applies to sqlserver. Even NASA software
> have bugs (I know a few personally).
>
> joe.
>
> Isaac Keslassy <keslassy_at_nospam.stanford.edu> wrote in message news:<3CC109C4.E7F5C2C1_at_nospam.stanford.edu>...
> > Hi,
> >
> > I would like to use a database with about 10 Gbytes and 25 million
> > lines. This would be via Intranet (IIS server).
> >
> > Would you know where I could find results of benchmark tests comparing
> > the performances of SQL server vs. Oracle with a similar database?
> > (answer speed, memory needed, etc.)
> > Given your experience, what would be the main pros and cons for each
> > solution?
> >
> > Thanks,
> > Isaac
Received on Mon Apr 22 2002 - 11:43:08 CDT