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

From: leebert <*GNOSPAM*leebert_at_mindspring.com>
Date: 2000/05/26
Message-ID: <392F3F9F.33497CFC@mindspring.com>#1/1

jijju_at_my-deja.com wrote:

> Fortunately I didn't have Opportunity to work with MS SQL server. Is it
> not good? Am I not saved from some pain?

Yes. MS rewrote the kernel. But MS broke outer joins on views, and took out 'abort tran on log full.'

The Transact-SQL parser is still Sybase's. Still has the same parser bug for block-comments w/ "go" statements. Hilarious. MS must still be paying Sybase license fees.

However, yes, I'd say that overall MS SQL 7 w/ SP 1 is more stable, IMO, than Sybase on NT or AIX. But the MS SQL backup mgmt tools are flakier than a french pastry. Instead of using xp_sendmail, MS decided to use MAPI. What a FUBAR mess.

> It is really fun to work with database products.

Ain't it though?

/lee Received on Fri May 26 2000 - 00:00:00 CDT