Re: SQL Server 7/2000 vs Oracle 8i

SQL Server didn't even have row-locking until version 7, as I recall. Doh!

In either case, Oracle provides enormous flexibility in precisely configuring your database instance. SQL Server does not, but some would like SQL Server because it is easier.

Triggers in Oracle are extremely flexible. With SQL Server (last time I checked), programmers were comparitively limited in the control they had over when a trigger executes.

Oracle 8i's "materalized views" (like views, but actually store data for perfomance) are not a feature SQL Server has yet - I *think*.

I think Microsoft is getting pretty close to Oracle, but I'd still give the the edge (RDBMS only) to Oracle. I'll be happy when I can clearly articulate the view that Microsoft is best. I'm tired of maintaining both.

On Thu, 31 Aug 2000 10:14:28 -0500, D.M.(Mike) Mattix <dmmattix_at_swbell.net> wrote:

>In article <39ae76df.3831088_at_news.mindspring.com>, jsneth_at_aol.com says...
>> Oracle 8i, in my opinion is a much more powerful full-featured RDBMS.
>>
>> SQL Server 2000, on the other hand comes with things that 8i doesn't
>> have:
>> o Data Mining
>> o OLAP
>> o DTS
>> o Better Visual Studio integration
>>
>> I use both on the same machine - 8i for the RDBMS, SQL Server for
>> everything else.
>>
>> On Mon, 28 Aug 2000 13:30:00 -0500, "Kurt Troyer" <katroyer_at_bcsew.edu>
>> wrote:
>>
>> >As far as adding the cost of NT to the cost of SQL server, it seems to me
>> >that we also pay for NT when we run Oracle on that platform. By the way, of
>> >course NT only runs on windows. DUH!
>> >
>> >
>> >"Malcontent" <malcontent_at_msgto.com> wrote in message
>> >news:39A61712.F652A811_at_msgto.com...
>> >> sergey_s_at_my-deja.com wrote:
>> >> >
>> >> > I beleive there used to be a SQL Server vs Oracle feature/performance
>> >> > comparison checklist on both the SQL Server web site and Oracle web
>> >> > site. However, I can't find either one any more. Can anyone point me to
>> >> > any URL that has that info (or something similar)?
>> >>
>> >> Here is the only one you need.
>> >>
>> >> NT only runs on windows. Oracle runs on just about anything.
>> >>
>> >> Oh yea don't forget the add the cost of NT to the cost of SQL server
>> >> when compairing costs.
>> >>
>> >> --
>> >> You can hit reply if you want "malcontent" is a legit email.
>> >
>>
>>
>I guess I am curious, in which ways is Oracle 8i a more powerful, full-
>featured RDBMS. I have used Oracle 8 (not 8i) and SQL Server V7 both on
>the NT platform and find some pluses and minuses for each but unless you
>have need for terabyte databases there was not much difference. SQL2000
>takes care of the terabyte database limitation now.
>
>These are just my experiences so please let's not get into a flame war
>over this. I am honestly looking for information.
>
>D.M.(Mike) Mattix
>david.m.mattix_at_monsanto.com
Received on Thu Aug 31 2000 - 16:00:22 CDT