Re: Oracle 10g compared to MS SQL SERVER

Mr Bob wrote:
Can anyone provide a comparative analysis between these two databases
that are halfway objective?

I have found one study:

http://www.theedison.com/index.php/articles/170

Has anyone read this study and/or have any comments?

Replication and Clustering are important.

I attended one meeting where a Project Manager stated that MS SQL
server is faster and requires less people to manage thereby saving on
manageability costs.......I almost fell out of my chair.....

Thanks
Mr. Bob

I'm going to have to respectfully disagree with Hans. The latest
studies show Oracle easier to manage than SQL Server and if one
is comparing Apples to Apples meaning Oracle Standard Edition
to SQL Server Enterprise then Oracle is not more expensive. One
only finds Oracle more expensive when applying the logic that
EE = EE which is not true in this case.

From my standpoint there are many things that Oracle SE does that
Microsoft can only hope to some day achieve. Does SQL Server have
a tecnology equivalent to RAC? No! Not for any price? To BEFORE
TRIGGERS? Not for any price? To sequences? To many other basic
Oracle capabilities? Not for any price. Can one create a secure
audit trail in SQL Server to comply with SarbOx? HIPPA? FACTA?
Basel II?

I'd suggest your product manager go Oracle and then invest in
providing some training for the employees so that they can use
the tool effectively.

Daniel Morgan
www.psoug.org
.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)