Which one better in performance and scalability ,Oracle 11g or SQL SERVER 2008
A:
The Oracle people will tell you that Oracle is better and the SQL Server people will tell you that SQL Server is better...who will you believe now?
SQLMenace
2010-05-28 12:53:56
any third party expert
andrew Sullivan
2010-05-28 12:54:53
Dammit, you should believe SQL Server people!
Dave Markle
2010-05-28 12:59:09
+1
A:
They're both excellent. How they perform and scale is dependent upon the following (in this order)
- The quality of the database design your developers create, including indexes.
- The quality of the queries your developers create.
- The quality and configuration of your hardware
- The database platform you choose.
Why? Mostly because Oracle and SQL Server use the same concepts and indexing structures underneath the hood, because they're based on the same underlying computer science.
Dave Markle
2010-05-28 12:57:21
-1 because web site refers to the entire MSSQL suite against only the Oracle 11g database. Oracle has an entire "development" suite and tons of add-on products too. In fact, Oracle probably has more add-ons and features in comparison to MSSQL (E Business Suites, embedded Java to replace PL/SQL in the database, a J2EE server, etc). I'm not saying that add-ons are always beneficial, but it's obvious this site's comparison is false.
Edwin Buck
2010-05-28 13:24:37