Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQL Server vs Oracle vs DB2 (&Sybase too)
ya know. you're right sql7 has many fewer levers to pull in the gui. with all the auto correcting features in 7 you dont need a dba, which is what microsoft wants and is a selling point for the product to the bean-counters. however, after thinking about it, my job is safe because microsoft - as with any other company - is so good at delivering large monolithic programs without bugs :)
personally, i think the more levers you have the better. if you dont want to deal with them just leave the defaults ( except for memory and connections - note: for non ms dbms's )
dave
In article <MZjY4.1223$MS2.38299_at_wagner.videotron.net>,
"Sinisa Catic" <sinisac_at_9bit.qc.ca> wrote:
> In my opinion this is the best point regarding MS SQL Server. You
> concentrate on developement rather than constantly tweaking database.
> Auto-tuning is now part of server engine (those years of research now
are
> included in the finished product). Biggest difference here is between
Oracle
> and SQL Server. MS SQL Server 6.0/6.5 has 51 parameters to tune, SQL
Server
> 7.0-43 params and SQL Server 2000 even less (I did not have time to
count
> them). Compare this with Oracle having at least 200 parameters.
>
> Sinisa Catic
>
> Norris <jcheong_at_cooper.com.hk> wrote in message
> news:8gps53$qnv$1_at_adenine.netfront.net...
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jun 01 2000 - 00:00:00 CDT