SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL or Oracle


SQL or Oracle

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: Administrators
Points: 65223 Visits: 19118
What's "won"? Not sure what that means. Faster, larger, price/performance?

I think they both have their places. I prefer SQL Server since it's cheaper, more complete with features, and fits my needs. Not that Oracle wouldn't, but at 1/2 to 1/4 the cost, why bother?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
David Benoit
David Benoit
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3492 Visits: 3650
Steve Jones - Editor (1/15/2009)
What's "won"? Not sure what that means. Faster, larger, price/performance?


Sorry, good question. Yes, faster, and better price performance especially since we were using partitioning which is included in Enterprise Edition of SS but is quite an expensive add-on with Oracle. The "run off" was primarily focused on which would perform better (faster) on like hardware.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
gints.plivna
gints.plivna
SSC-Enthusiastic
SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)

Group: General Forum Members
Points: 124 Visits: 433
Define best. For me best is Oracle because I've used it for more than 10 years and just a little bit looked in SQL Server. Oracle for me would most probably be faster, more reliable and usable for me because I know how to configure, develop and use various its features. It isn't so with SQL Server so the reason why.
The first thing is to understand that each DBMS is different and what is better for me, won't be better for you and what is better for project X, won't be better for project Y.
It is OK to compare them, but there is one big problem - there are very few people really knowing both of them and really understanding that even if there is not direct mapping for feature X in other DBMS, there are various another ways how to accomplish that.
So ultimate seeking for which is better is useless at least to my mind.

Gints Plivna
http://www.gplivna.eu
David Benoit
David Benoit
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3492 Visits: 3650
All good points and to further what Gints is saying, you do have to take into consideration what skills are prevalent in your organization and / or your community. Where I am at there is not an abundance of SQL Server but there is a ton of Oracle so, you can find Oracle DBA's by the dozen.

Thanks for that insight!

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)

Group: General Forum Members
Points: 89577 Visits: 41144
gints.plivna (1/15/2009)
Define best.


Not a problem... Which can someone write the highest performance code in that correctly does the job in the shortest time for the least amount of money with the least amount of maintenance? Wink

The first thing is to understand that each DBMS is different and what is better for me, won't be better for you and what is better for project X, won't be better for project Y.


Heh... Agreed... See definition of "Define best" above.

It is OK to compare them, but there is one big problem - there are very few people really knowing both of them...


Now THAT would be interesting. Any of you folks out there good at both? If you are, I for one sure would like to hear from you on which you think is best and why. Seriously...

So ultimate seeking for which is better is useless at least to my mind.


I do understand what you mean here... which is best for the PROJECT? See "Define Best" above. Smile

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
hb21l6
hb21l6
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 294
It would appear that I have made a bit of a stir with this question. Sorry all,
I think I’ll just stick at my MS SQL. Should be ready to sit my first exam soon. :O)
Roshan Jospeh
Roshan Jospeh
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1641 Visits: 2087
Like Gints / Jeff said, only a veteran in both Oracle and MS SQL can give a defenite (and objective) answer based on their hands own experience. Even then people tend to develop a personal liking for one over the other based on how much natural they are in it.

Better we apply theory of relativity here also?Wink

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
noeld
noeld
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10034 Visits: 2048
There are *many* things Oracle can do that SQL Server can't. So much so, that Oracle is normally being refused because of its too many knobs....

Now that being said for a very large percentage of of the applications out there many of those knobs are NOT required and SQL Server excels at that. But for those where fine tuning to the T is critical Oracle is *the* way to go.

If
1. We forget about money (note normally we don't Wink ) assume money is not a problem (nice, isn't it).
2. We Forget about knowlege of the DBA; assume we have infinite knowlege about both products.
and we want a task done as best as it can be done probably the solution will end up in Oracle's hand.

There are applications like "military", "space", "nuclear power controls", "Medical Applications", etc in which money is a factor that goes AFTER precision,reliability,...etc.

Granted, once again, these are NOT typical applications just something for you to think about.

On the other hand for a very large number of common scenarios, SQL Server provides what we need and is very convenient in terms of manageability and programmability.

Just my $0.02


* Noel
GSquared
GSquared
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24453 Visits: 9730
noeld (1/16/2009)
There are *many* things Oracle can do that SQL Server can't. So much so, that Oracle is normally being refused because of its too many knobs....

Now that being said for a very large percentage of of the applications out there many of those knobs are NOT required and SQL Server excels at that. But for those where fine tuning to the T is critical Oracle is *the* way to go.

If
1. We forget about money (note normally we don't Wink ) assume money is not a problem (nice, isn't it).
2. We Forget about knowlege of the DBA; assume we have infinite knowlege about both products.
and we want a task done as best as it can be done probably the solution will end up in Oracle's hand.

There are applications like "military", "space", "nuclear power controls", "Medical Applications", etc in which money is a factor that goes AFTER precision,reliability,...etc.

Granted, once again, these are NOT typical applications just something for you to think about.

On the other hand for a very large number of common scenarios, SQL Server provides what we need and is very convenient in terms of manageability and programmability.

Just my $0.02



Actually, for mission-critical reliability, a number of military projects have been switching from Oracle to a database product called Cache. Major pain to work with, but it apparently is much more robust.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
timothyawiseman
timothyawiseman
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1260 Visits: 920
My opinion is definitely slanted since I earn my living with SQL Server and have only used Oracle in an academic environment, so I have vastly more experience with SQL Server than Oracle.

But, having experience with both, I will join the majority and say "It depends". In the vast majority of cases, I would take SQL Server in a heart beat. It is easier to use, easier to administer, and has vastly better tools that come with it. I would even happily toss the tools that come with SQL Server against the best tools you can buy for Oracle in most projects. It is also easier to write applications for. (As a disclaimer again, I have more experience in SQL Server, but I have used and written code for both).

While I would say SQL Server would win in most cases, there are 3 areas where I would pick Oracle:
1. Cross platform development since Oracle is available with very few differences on both Windows and Unix.
2. Scaling out. SQL Server has very limited ability to scale out right now, where Oracle is very robust there. I'm hoping SQL Server will catch up soon.
3. If it is necessary to maintain legacy applications already written in Oracle, (or legacy employees already trained in Oracle).

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search