SQLServer vs. Oracle
Ray Little
Can anyone give me SQLServer's advantages over Oracle?
Thanks,
Ray Little
Saviram Lior
Price, Preformance (http://tpc.org), TCO, Integration, ease of use, market
share, inovation (MTS, PANORAMA, FALCON, WOLF PACK), look at
microsoft.com/sql for refferences
Ray Little <rli...@psinet.com> wrote in article
<3321b9ab....@usenet.psinet.com>...
Joe Space Invader Foster
> Can anyone give me SQLServer's advantages over Oracle?
> Thanks,
> Ray Little
You can just load it and go. You don't have to memorize three
meters of administration manuals first. The SQL is closer to
other RDBMS', such as Sybase and SQL Anywhere. Configuring
client stations is much easier. Larry Ellison can't sacrifice
your plans on the multimedia altar.
--
Joe Foster (j...@bftsi0.gate.net or joe%bft...@uunet.uu.net)
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!
Tim Schwallie
SQL Server is easier to put into place.
Oracle documentation is available, but a bitch to work with compared to
infoviewer.
They put all their documentation in PDF's the last version I saw. Ever
tried searching across PDF's, can't do it...I really hate PDF's and their
use as helpfiles
SQL Client is easier to put into place than SQL*NET.
Oracle administration tools are getting easier, but a pain to put into
place and get to work.
SQL Server Enterprise Manager works.
Oracle in the past has provided more control in critical areas of
performance. SQL 6.5 is catching up.
Oracle PL/SQL blows away TSQL.
Oracle Trigger control works at the record level and transaction level both
before and after. MS has transaction level trigger, no row level, and I
think it is only an after type trigger.
Oracle works with rows level locking.
SQL Server 6.5 uses page level and can use insert row level locking if it
is turned on.
Oracle provides for segmented tables.
Oracle's tablespace concept vs SQL Database domain concept when working
with security and ownership. Can't say which is better.
Oracle provides better control of space usage. May be applicable depending
on how billing is perfromed for space.
Yeah, the comparison goes on and on.
Here's a general conclusion I had to make in a document I wrote on this:
Oracle and SQL Server are quite comperable tools for client/server
development. However, SQL Server continues to play catch up. Oracle
provides more options to the DBA and developers, but are the options
necessary?
Other areas to look at: Support, future versions and what they will offer.
Don't worry about speed, it usually comes from design anyway. They both
have it and NT 5.0 will make them both faster.
Protability, Oracle databases can be ported to other platforms. Sorry,
today's Intel processors and architecture can't match a 3 year old DEC
Alpha.
Joe "Space Invader" Foster <j...@bftsi0.UUCP> wrote in article
<74...@bftsi0.UUCP>...
Bryan Warfield
Ray Little wrote:
>
> Can anyone give me SQLServer's advantages over Oracle?
>
> Thanks,
> Ray Little
I've used both for over a decade (Sybase/MS SQL-Server since 4.2 and
Oracle since 5.0) and prefer working on Oracle 7 / Unix platform because
it scales so much better (last year I ran Oracle on both a 24-processor
SMP Cray AND on my 90 Mhz Dell notebook). However, Oracle is extremely
complex and not everyone needs it's capabilities. SQL-Server may be
more appropriate for smaller systems (up to 4-processor SMP). Just
remember to run those DBCCs. hope this info helps,
Bryan Warfield
(opinions are my own, not necessarily same as my employer).
Andrew Knight
In article <332703...@DAL.frb.org>, Bryan Warfield
<Bryan.W...@DAL.frb.org> writes
>I've used both for over a decade (Sybase/MS SQL-Server since 4.2 and
>Oracle since 5.0) and prefer working on Oracle 7 / Unix platform because
>it scales so much better (last year I ran Oracle on both a 24-processor
>SMP Cray AND on my 90 Mhz Dell notebook). However, Oracle is extremely
>complex and not everyone needs it's capabilities. SQL-Server may be
>more appropriate for smaller systems (up to 4-processor SMP). Just
>remember to run those DBCCs. hope this info helps,
to corruption than Oracle7? I'm about to make a choice between them on
for 30-40 user NT based system.
Andrew Knight e-mail: a...@tsm.co.uk
TSM Systems tel : +44 181 673 7750
London fax : +44 181 673 1335
http : www.tsm.co.uk