Re: Oracle8i vs. SQL Server 2000

SQL Server may one day just become the best server on Earth, you never know. However, if you are not a Windows shop then Microsoft products (almost all of them) are not even a choice. I doubt that Microsoft will start offering SQL Server for UNIX. So, then the question comes down to Windows vs UNIX and that's another story.

If you are a Windows shop then SQL Server may be a less expensive solution than Oracle while still providing the necessary performance. Personally, I haven't had much success with SQL Server 6.5 or 7 (performance-wise). In fact, Oracle has outdone it every time (im my cases).

Why do you think one of your departments is considering switching to SQL Server? Are there problems with Oracle servers in place? Is it the cost?

If it's the cost than, probably, SQL Server is the way to go - it will keep getting better.

Sergey

In article <399E08EE.E730BBCB_at_netzero.com>,   rmpowell_at_netzero.com wrote:
> Peter,
>
> You should advise your group that is contemplating such a major SNAFU
 that
> SQLServer at best is only scalable on the NT environment. It cannot
 take
> advantage of the scalabilty available to Oracle. Also there were
 major
> concerns over the last release's ability to support > 50 concurrent
 users.
> This to my knowledge has not been addressed. Also you will want to
 consider
> that SQLServer has NEVER been 7 X 24 unless you forgo good backups.
 You
> cannot now nor have you been able to run a recoverable backup on this
 product
> without running DBCC in single user mode. This is a carryover from
 when
> Microsoft purchased SQLServer from Sybase.
>
> For your sake make them aware of what this option limits the company
 to. If
> I were you I would refuse to support it and look for another job. If
 you are
> an Oracle DBA that should not be a problem.
>
> Rick Powell
> yensid_at_watsoncable.com
> OCP DBA
>
> Peter Livingwater wrote:
>
> > I saw presentation slide, but I can not locate in the web.
> >
> > Ernest D. Stalnaker <ernest_at_purdue.edu> wrote in message
> > news:8i64ls$e3m$1_at_mozo.cc.purdue.edu...
> > > Does anyone know of any whitepapers or other documents that
 compare the
> > > features of Oracle8i vs. Microsoft SQL Server 2000? I know that
 SQL
 Server
> > > 2000 is still in beta, but it is supposed to be released sometime
 this
> > > summer. We are primarily an Oracle shop, but one of our
 departments is
> > > considering switching to SQL Server, so I want to be able to give
 them
 some
> > > accurate information on the pros & cons of making the switch.
> > >
> > > Thanks in advance to anyone who can help me!
> > >
> > > Ernest D. Stalnaker
> > > Database Administrator
> > > Management Information
> > > Purdue University
> > > West Lafayette, Indiana
> > > E-Mail: ernest_at_purdue.edu
> > >
> > >
> > >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 21 2000 - 20:42:53 CDT