Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQL Server vs Oracle vs DB2 (&Sybase too)

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

From: Kizzy <kizzyns_at_azstarnet.com>
Date: 2000/06/01
Message-ID: <sjdceshv5ri179@corp.supernews.com>#1/1

SQL Server reads/writes native format bcp files from Sybase (DEC 4.0F Unix 10.03/11.0.3 ASE at least). I find this extremely useful.

<siuhungkuen_at_my-deja.com> wrote in message news:8h6794$7p5$1_at_nnrp1.deja.com...
> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US