Re: Oracle and Microsoft SQL Server

For the SQL server experts, I have a honest question, how does SQL server
handle data insert/update without row-level locking? It cannot be locking the
whole table??

rrbatra_at_feist.com

Bill Bearden wrote:
>
> The comment below that SQL Server 6.5 is a strict subset of Oracle 5.x is
> ridiculous. Oracle 5.x was fairly backward compared to today's RDBMS's.
> Oracle's great leap forward was Oracle 6. That is when Oracle began its
> march to #1. IMNSHO, Oracle RDBMS is #1 and by a good sized margin,
> especially for large applications.
>
> <rebuttal to stupid comment>
> * SQL Server has temporary tables (very handy!). Oracle does not.
> * SQL Server has the 'money' datatype. Oracle does not.
> * SQL Server has bcp, a great input/output utility (In and out have same
> syntax!). Oracle has SQL*Loader, a great input utiltity (when Oracle adds
> unload to SQL*Loader, it will win easily)
> * Don't even talk to me about copying entire 1GB tablespaces which only
> have one row. (No, export is not a valid hot backup technique...)
> </rebuttal to stupid comment>
>
> Overall, Oracle has the features war won. Overall, it isn't even that
> close. But Oracle is also much more complicated than SQL Server. While
> this excites me (we won't go in to that), some users are not willing to
> make that trade off. And that is how it should be.
>
> Bill Bearden
> Consultant
>
> Mark McNulty <mmcnul_at_jpmorgan.com> wrote in article
> <5o8qph$l8f$1_at_hardcopy.ny.jpmorgan.com>...
> > In article 920_at_feist.com, rrbatra <rrbatra_at_feist.com> () writes:
> > [snip a bunch of good points before this stinker below]
> >
> > > There is nothing which SQL Server does and Oracle does not. In fact,
> > > all features found in SQL server 6.5, were there in Oracle 5.x or
> > > so...For a list, look in any PC week, Oracle loves comparing it with
 SQL
> > > Server.
> >

 <stuff snipped>
> >
> > Actually, while Oracle does have some good features, SQL Server(and
 Sybase)
> > do have some that Oracle doesn't, especially those related to stored
> > procedures, where Oracle is actually behind. Try returning multiple
> > rows, or even multiple result sets, from an Oracle stored procedure. In
> > Oracle, you have to use a work-around. In Sybase, I can say
> >
  Received on Thu Jun 19 1997 - 00:00:00 CDT