Re: MSSQL vs Oracle - Just the facts

Against MSSQL:
can't get very big
(single-row fetch on 36Million row table: 47 seconds vs Oracle 8 of 0.5 on same machine)
Transact SQL is so pathethic. Hire a C++ programmer (or, yech, VBA)

Pro:
(Just about) anybody can be a DBA
Finally added case statement (7.x)

Against Oracle:
Need support? forget it, not today.
Price.

Pro:
Very rich programming language (PL/SQL) can get quite large

Matt Randle <NOSPAMmatt_at_imat.demon.co.uk> wrote in message news:943458640.11996.0.nnrp-04.d4e48d0d_at_news.demon.co.uk...
> How about,
>
> Against SQL,
>
> No cascading deletes
> No rowid's
> No table sizing
>
> For,
>
> Cheaper
> Better admin tools
> Free OLAP
>
> It seems to me Microsoft is competing on price only. For alot of systems
> SQL Server is good enough + the fact that it is so much cheaper means it
is
> making inroads into Oracles market share.
>
> Matt.
>
>
>
>
>
>
Received on Wed Nov 24 1999 - 11:43:27 CST