Difference Between Sql/Server and Oracle
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Difference Between Sql/Server and Oracle

  1. #1
    Join Date
    Jan 2003
    Location
    Edmonton, Canada
    Posts
    16

    Difference Between Sql/Server and Oracle

    Hello,

    I would like to know the key difference between sql/server vs oracle.

    thanks
    nat
    Nat

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    • Platform independence
    • Scalability
    • ... feel free to add more
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Aug 2001
    Posts
    267
    Did your Oganization wants evaluate both products ??

    Search google .. You will find so many links for comparision.
    Raghu

  4. #4
    Join Date
    Jul 2003
    Posts
    323
    This reminds me to post:
    Any1 here administering both Oracle and Sql server as I may have to do the same i.e manage a couple of SQL server db's sometime in the near future and was wondering if I could get any pointers on getting upto speed.


  5. #5
    Join Date
    Feb 2001
    Posts
    295
    My impressions, since I work with both:

    SQL Server has some nice features like DTS and the SQL Server Agent, much easier to configure than Oracle.

    However, when properly used Oracle is quite more powerful. It seems the approach on 10g is to make the DB as easy as MSSQL.

    The better choice falls on the obvious considerations of scalability, costs and sizing.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    one thing on sql server i cant forget is "Locking mechanism sucks in MS Sql Server"

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    concurrency control is not the same in SQL Server and oracle.
    David Knight
    OCP DBA 8i, 9i, 10g

  8. #8
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Originally posted by abhaysk
    one thing on sql server i cant forget is "Locking mechanism sucks in MS Sql Server"

    Abhay.
    IMHO, in SQL Server 6.5 the locking mechanism was pathetic.
    It has improved a lot since then.

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by gandolf989
    IMHO, in SQL Server 6.5 the locking mechanism was pathetic.
    It has improved a lot since then.
    So was 7.x.. But 2000 is also no good ..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  10. #10
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Originally posted by abhaysk
    So was 7.x.. But 2000 is also no good ..

    Abhay.
    I once worked at a place that had a SQL Server 2000 cluster running with over 1,200 concurrent users pounding it all day, and SQL Server worked fine. Tha'ts not to day that I prefer SQL Server, instead I prefer Oracle for the number of things that I can do with it.

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