Re: Oracle versus Sqlserver

And any comments about the most important differences between them such as multiversioning, the transaction models, and locking?

Daniel Morgan

Dana Day wrote:

> Hello all,
>
> I am a DBA with both platforms, using each for the past several
> releases.
> I do not claim to be omnipotent in either. I do believe they both have
> a place in the industry.
>
> SQL Server does indeed position itself as a step up from MS-Access.
> Why not? It is a step up.
>
> Oracle has some strengths also. The "average" Oracle DBA likely is
> considerably better versed in RDBMS theory and practice. The "average"
> Oracle system is usually better designed, and maintained.
>
> I believe this happens because Oracle staff generally have more (and
> more intense) training. You don't step up to Oracle; you either train
> for it or come from another platform with rather stringent
> requirements for user/admin proficiency.
>
> SQL Server DBA's are often stepping up from Access, and, in my
> experience, are not as intensely trained. I don't see this as evil.
> SQL Server has brought SQL and RDBMS technology a much broader
> exposure. Shops that would never consider Oracle jump into SQL Server
> quite easily.
>
> I believe SQL Server is easier to manage and maintain at a lower cost.
> This makes for a good small shop entry into RDBMS systems.
>
> Oracle is probably still better on a large box, due to its Unix
> compatibility.
> I definitely prefer Oracle for larger, single box solutions.
>
> As for clustering, I think it is six of one, half a dozen of another.
> A shop with more NT platforms/experience can do better with SQL Server
> than Oracle.
> A shop with lots of Sun/AIX/HP monster boxes can definitely do some
> major Oracle implementations.
>
> Whichever approach is taken, I see that as a net gain for the
> industry.
>
> Sincerely,
>
> Dana Day
> MS-SQL Server/Sybase/Oracle DBA
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3c4693f1$0$237$ed9e5944_at_reading.news.pipex.net>...
> > funny how this list reappears with annoying frequency and is always posted
> > to the oracle NG and never to thge sql NG where people who are qualified to
> > comment upon it might do so.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
Received on Mon Jan 21 2002 - 06:04:09 CST