DBAsupport.com Forums - Powered by vBulletin
Page 1 of 7 123 ... LastLast
Results 1 to 10 of 63

Thread: Oracle Vs SQLServer

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends.

    I am curently having discussions with a SQLServer Guy who believes that SQLServer is the best RDBMS available.

    I am trying to argue the case that Oracle is better but don't know what real advantages it has over SQLServer.

    Considering that I am representing Oracle DBA's here can anyone give me a rundown of why Oracle is better so that I can put him in his place once and for all.

    Cheers

    Suresh

  2. #2
    Join Date
    Jun 2001
    Posts
    7
    Here's the best reason.

    IT'S NOT A MICROSOFT PRODUCT!

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi Suresh,

    Why dont you use the search option available at this site and use the search option on

    http://www.google.com

    In the search option just type the following

    "oracle vs sqlserver"

    and click search

    I did that today I found so many links and discussions going on

    Hope this helped

    Regards
    Santosh

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Follow the general rule:

    If the database size is < 100 GB, use SQLSERVER.

    If the database size is >= 100 GB but <= 2000 GB, use Oracle.

    If the database size is > 2000 GB, use Teradata.



  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check the site: http://www.oracle.com

    There is an article that talks why oracle is the best. Even though MS says that they are the best, it cannot scale like oracle. They can be managed easily, where as oracle requires some knowledge. Performance in oracle is always better when compared to the sqlserver, provided it was well tuned. On the other hand FYI, it was said that sql server surpassed oracle by a tiny margin on the last survey, for its cost, Oracle is now considering a cost cutting for its 9i. One other thing you can always square a person is asking that whether it could run at any platform, voilla, the argumentee's mouth would be ziped

    One other thing that you can point out is that the world's largest database runs on ORACLE.


    Hope these would help.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The world's largest database runs on Teradata not on Oracle.

  7. #7
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Teradata is from which company? IBM? Thanks for help.

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Teradata is from NCR.
    The 2 big shops in US, WAL-MART and KMART have been using Teradata for the past 12 years. The DB size is more than 90TB as of today.

  9. #9
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    Hi, 14th June 2001 21:58 hrs chennai

    Both Tamil and Sambavan has said in Crisp the truth still if you are not happy more to do a research go on with this.

    1)Both (oracle & sql server) are based on RDBMS technology and this technology has follow some set of rules (E.F. Codd's rules). The maximum rules has been applied by oracle company, so far.

    That's why it has worth.

    2)http://www.baanfans.com/baanfans/forum/other/messages/627.html

    3) A comment from a real time user from a web site

    I have used MS SQL Server on several Windows NT only projects with ASP and ActiveX. I have used Oracle 8i with PHP. After getting used to Oracle, PL/SQL cursors etc., and Oracle 8i Java options I started complaining about MS SQL Server. MS SQL Server lacks many features of Oracle, so if you need the best of the best pick Oracle. The downside is, that in order to be able actually utilize all the nifty Oracle tricks you need pretty skilled programmers. And Oracle is pretty expensive. Another thing about Oracle is that it is a little thougher to administer. So I would choose Oracle on projects where you have enough skilled manpower.

    4)A strong Wicket for Oracle

    http://www.hronline.com/forums/hris/9905/msg00046.html

    Oracle has well proven all ready with its DB market share.if it had been people would have gone for that. So this one is more than enough to say Oracle is a Leader as of now.

    Good Luck for SQL Server in future.

    Cheers

    Padmam

    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx to Tamilselvan, on correcting my spec on world's largest database. My assumption was based on the following link from oracle, I hope its true


    http://www.oracle.com/features/insid...nvanie_04.html


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width