Oracle 10g versus sqlserver 2005

  • We are evalauting oracle 10g versus sqlserver 2005. Our data center is set up such that automatic data and machine failover is avaialble hence that is nto a concern. Cnncern is the databaase is a large OLTP database (arounf 600 GB) that has a lot of users and extreme volatility in terms of data additions and deletes.Based on dates we delete a lot of data and then re add. In sqlserver we have used partiniong of tables to achive this effectively in the past. We need a great BI platform that integrates well with the DB as well as .NET and EXCEL and productivity of develoeprs is enhanced. Both sql and oracle our good dbm's. THE QUESTION IS WHICH ONE TO CHOOSE. What shoudl be teh paramters in teh technology offerings I shoul dlook for to differentitae the two and make a decision.

  • My inputs based on working on both the dbs:

    1. SQL Server 2005 is eqally good as Oracle 10g in performance etc.

    2. The other parameters you can consider are which OS you are using

    for the db instances. SQL Server will not work on other than

    windows as of now.

    3. The skill sets of the dev and admin personnel you have.

    4. One strong point of SQL Server is much much more better

    integration with products like .NET, Excel and others. SSIS which is

    part of SQL Server is an unparalleled tool.

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]

  • Mazharuddin Ehsan (7/26/2008)


    My inputs based on working on both the dbs:

    1. SQL Server 2005 is eqally good as Oracle 10g in performance etc.

    2. The other parameters you can consider are which OS you are using

    for the db instances. SQL Server will not work on other than

    windows as of now.

    3. The skill sets of the dev and admin personnel you have.

    4. One strong point of SQL Server is much much more better

    integration with products like .NET, Excel and others. SSIS which is

    part of SQL Server is an unparalleled tool.

    Go with SQL Server all the way!! 🙂

    Where to start...

    Do you want outstanding support that responds to your issues within 24 hrs. (or sooner depending on your contract)?

    Do you want a platform that is familiar to more people than any other RDBMS thereby making it easier to hire and maintain personel for your organization?

    Do you want a product with unparalleled support for Business Intelligence, that ships with 3 excellent components - SSIS, SSAS and SSRS?

    I've worked with ORACLE, and, in terms of user experience, I have found it to be far inferior to SQL Server. Not that SQL Server does not have problems, it does. But, overall, I find SQL Server more intuitive and easier to work with. With features such as the new Isolation Levels introduced in the 2005 version, SQL Server is now on par with ORACLE in terms of concurrency and scalability.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • A while ago I wrote an article How to choose database indicating some criteria one should look at.

    Gints Plivna

    http://www.gplivna.eu

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply