Re: MS SQL Server vs Oracle vs DB2 (&Sybase too)

jijju_at_my-deja.com wrote:

> Sybase is much better compared to Oracle and
> DB2. Especially the SQL based stored procedure is good
> and comes handy.

Oracle has PL-SQL. I thought it was pretty good , as good as Sybase's T-SQL from what my Oracle friends have told me.

DB2 ver. 7 will have SQL-PL based on a proc language standard.

> temp database is very handy to resolve many big quiries.

Let's not forget MS SQL has tempdb, w/ #tables as well. And w/ DB2, you can give the users their own schema that serves the same function.

> Updates are powerful with joins.

I thought DB2 has these.

> Replication concept is much better in Sybase than other databases.

Really? I'm curious how that is.. MS SQL does 3 kinds of replication. I'm not impressed by DTS, but DirectConnect ain't a breeze either.

> No other database is that
> powerful as sybase.

later self-contradicted by:

> However Db2 ver 7 come with much powerful SQL support and refined database concepts.

Yes. DB2 v. 7 is going to kick some butt.

> it is always
> not Oracles defect, It is only your poor understanding of database
> technique. You shouldn't be surprised If they ask to change either the
> machine or the DBA. Oracle is the real pain.

This is what I've heard. Arrogant.

> All are equally competent in releasing the product with bugs.

Yup. But MS doesn't document patches made to MS SQL's kernel. BIZARRE!

> two simple insert / update would result in dead lock. Hope it is fixed
> in the latest release, I didn't get an opportunity to verify.

We fixed that by going w/ 3 or 4 named caches & segments for a table... that way the spinlock is spread out. But still a pain, yes.

But we've also seen index page contention on DB2 UDB as well. Similiar approach w/ DB2: Keep the commit size down & add more tablespaces. Again, row-versioning (Oracle, Interbase, Postgres) will ultimately be the best sol'n for concurrency issues, I think ultimately all DBMS vendors will go to row versioning.

/leebert

+-----[ http://leebert.home.mindspring.com ] --------+ It is impossible to begin to learn that which one thinks one already knows. -- Epictetus (c.55-c.135) Received on Sat May 27 2000 - 00:00:00 CDT