Re: ADO.NET and SQL, Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yuri,

Thanks for your views. I do agree with your views in many dimensions, but I
disagree that SQL Server 2005 (not 2000) cannot be used appropriately to run
on a 2 TB database. In fact, even SQL2k can do that (really depends on your
DBA).

I agree with your assessment on rollbacks.

Now one thing that I'd like to point in addition to your answer below is
"Licensing Cost". And once you consider that, the little bit of pain SQL2k5
will give you in comparison with Oracle, is worth the multi million $
savings, don't you think?

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------


"Yuri Nogin" <ynogin@xxxxxxxxxxx> wrote in message
news:%23XQwWmBpFHA.3036@xxxxxxxxxxxxxxxxxxxxxxx
> Alright,
> I see it's a hot discussion.
> I'd like to give my 2 cents on this subject. I'll give you some insight
> on my career first so you would know that it's coming from my personal
> experience.
> I'm currently working as a DB2 and SQL Server 2000 administrator. In the
> past I was a BI architect working with both Oracle and SQL Server
> databases primarily. I'm an MCP and OCP.
> When comparing feature for feature Oracle 10g, DB2 8.2, and SQL Server
> 2000. Oracle is the richest database for development and maintains hands
> down. DB2 is only working to introduce a true partitioning in the next
> version (range) while Oracle has 3 types of it and supports
> sub-partitioning as well. Oracle had range partitioning since version 8
> (this is more than 8 years ago). This is just an example. As a developer
> you have tons of features that you can't find in any other database.
> Now, SQL Server 2005 comes close (still behind) but a lot closer than
> SQL 2K. Also Oracle is the only database that has a different rollback
> mechanism vs. all other databases (SQL Server, Sybase, DB2). It's "very
> hard" to get a "dead lock" situation in Oracle. Of course from your
> experience you probably know it's very easy to catch it in SQL Server or
> DB2. I can go on and on here. PL/SQL is by far superior to TSQL. Now,
> said this I still like SQL Server (for small and "quick and dirty"
> projects). If you get to the Enterprise Multi Terabyte database systems
> you may want to wait for SQL Server 2005, or use Oracle. BTW I have
> experience using SQL Server 2000 with 2 TB of data. It was not easy at
> all.
>
> Thanks,
>
> (\\\|///)
> (\ - - /)
> @( @ @ )@
> ---oOOo-(_)-oOOo---------------
> Yuri Nogin, MCP, OCP
> Currently DB2 administrator
> -------------Oooo--------------
> oooO ( )
> ( ) ) /
> \ ( (_/
> \_)
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Why not Access...?
    ... Next, I DID NOT SAY Oracle was considered a "best choice," only a sufficient ... It is a desktop application and the database in also on the same machine. ... I also want to know why Oracle is considered a best choice as compared to SQL Server. ... > Also, you need to answer the question regarding whether or not each client> will be using an individual database, and individual copy of a central> organization database, or making straight calls to a centralized ...
    (microsoft.public.sqlserver.server)
  • Re: Merge/Replication or Syncing with Oracle
    ... You can't directly access an Access database on the desktop from a WM 5 app, but you can sync between SQL Compact on the WM device and Access using the Access Syncronizer: ... As for the Oracle issue ... ... Where SQL Compact Edition easily does merge/replication to SQL Server using IIS ... ...
    (microsoft.public.sqlserver.ce)
  • Re: Oracle vs SQL Server as a back end for Access?
    ... post -- comparing back end database engines or replacing the front end ... say that Oracle 10g is better than SQL Server 2000 without determining ... whether or not the total cost of ownership of 10g over SQL Server ... developer than Oracle 10g, in spite of its new web interface. ...
    (comp.databases.ms-access)
  • Re: Oracle licence question
    ... And no - it does not freeze anything, the backups DO NOT affect connections ... SQL Server MVP ... freeze the database and send it to the target. ... What I really wanted is something that lists features I get in Oracle ...
    (comp.databases.oracle.server)
  • Re: ADO.NET and SQL, Oracle
    ... I?m currently working as a DB2 and SQL Server 2000 administrator. ... Oracle is the richest database for development and maintains hands ...
    (microsoft.public.dotnet.framework.adonet)