-
Difference Between Sql/Server and Oracle
Hello,
I would like to know the key difference between sql/server vs oracle.
thanks
nat
Nat
-
- Platform independence
- Scalability
- ... feel free to add more
-
Did your Oganization wants evaluate both products ??
Search google .. You will find so many links for comparision.
Raghu
-
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.
-
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
-
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"
-
concurrency control is not the same in SQL Server and oracle.
David Knight
OCP DBA 8i, 9i, 10g
-
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.
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|