Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Why SQL Server is Better Than Oracle


Why SQL Server is Better Than Oracle

Author
Message
tbredeme
tbredeme
SSC Eights!
SSC Eights! (876 reputation)SSC Eights! (876 reputation)SSC Eights! (876 reputation)SSC Eights! (876 reputation)SSC Eights! (876 reputation)SSC Eights! (876 reputation)SSC Eights! (876 reputation)SSC Eights! (876 reputation)

Group: General Forum Members
Points: 876 Visits: 78
Oracle *is* user friendly. It's just selective about who its friends are.



It's not a bug, SQL just misunderstood me!

Artificial Intelligence stands no chance against Natural Stupidity.
Charles Kincaid
Charles Kincaid
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1041 Visits: 2383
Carl Federl (10/4/2007)
Q: How many Oracle DBAs does it take to change a light bulb ?

A: Three - it takes three Oracle DBAs to do anything.



Q: How many SQL Server DBAs does it take to change a light bulb ?

A: None - SQL Server automatically changes light bulbs.





Would you mind notchanging the light bulbs while I'm trying to read?!



There is no truth to the following rumors:

MySQL is proposing changing WHERE to WHEN to emphasise the "real time" nature of the Falcon engine.

Oracle touts it complexity as a new "security" feature.

DB2 introduces ROLL OVER for transactions to make the succeed even if there are conflicts.

SQL Server introduces SORT OF and KIND OF as extentsions of LIKE to make things more warm and fuzzy.



No truth, I tell you. NO TRUTH!!

ATBCharles Kincaid
jay-h
jay-h
SSC Eights!
SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)SSC Eights! (925 reputation)

Group: General Forum Members
Points: 925 Visits: 2222
When my son got married I went out for drinks with a bunch of his friends.



You haven't lived till you get roasted by a bunch half drunk Oracle guys.

...

-- FORTRAN manual for Xerox Computers --
Ed Klein-385786
Ed Klein-385786
SSC Journeyman
SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)

Group: General Forum Members
Points: 99 Visits: 467
You comments about being less formal with the people you like, reminded me of a passage from "The Gulag Archipelago" by Solzhenitsyn. In it he stresses that "your friends will argue with you". If he told someone that he was going to do something stupid, like talk back to the guards, his friends were the ones trying to talk him out of it. The guy who was encouraging him, saying "Yea, tell them what you think" might appear to be supportive, but in reality they were definitely NOT his friend.



I've been know to play "devil's advocate" with system designs and some people accuse me of arguing too much. I just tell them about Solzhenitsyn and let them know that I'm "very friendly" Nothing solidifies a design like having to defend it against alternatives.
Francisco Lopez
Francisco Lopez
SSC-Addicted
SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)SSC-Addicted (455 reputation)

Group: General Forum Members
Points: 455 Visits: 45
Let's get down to it gentleman, I think Oracle sucks but I have learned to like it - sort of. It is more like a living arrangement.



In my experience Oracle DBAs make more $mula$. The entry level for Oracle is higher. I am not sure if Oracle did that on purpose.



Ah, you have not lived until you set up Oracle Management Server - something that is basically out of the box in MS SQL.



At the same time, there are things that are in Oracle that I wish MS SQL had and vice versa.


{Francisco}
Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3290 Visits: 2476
"SQL Server is better than Oracle"



"Why?"



"Because"



"Why Because?"



"Because it just is"

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3254 Visits: 11771
Carl Federl (10/4/2007)
Q: How many Oracle DBAs does it take to change a light bulb ?



A: Three - it takes three Oracle DBAs to do anything.







Q: How many SQL Server DBAs does it take to change a light bulb ?



A: None - SQL Server automatically changes light bulbs.





The new Oracle light bulbs are $100,000 each plus $1,000 for every one who sees the light, and old light bulbs aren't licensed to work with the latest version. If you have 220 volts, instead of 110, it's another $100,000.
Loner
Loner
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2918 Visits: 3329
Oracle's boss is Larry Ellision, he did anything to try to be number one. Oracle is behind Microsoft right now. After he took over Peoplesoft, he just bought Hyperion. In an article I read a while ago in Time or Newsweek magazine, he was arrogant, competitive and rude.

I worked with Oracle consultants a lot, when you bought Oracle, you needed to hire Oracle consultant, the damn thing was so complicated that no one knew what to do when they got it from the box. Most of the independent consultants were very nice. But the one who worked at Oracle somehow got Larry's influence - arrogant and rude. Even the Oracle DBAs attitude were different from SQL Server DBAs. They felt they were more superior. Maybe just the Oracle DBAs I met !!!!



As far as programming, Oracle SQL is the same as SQL Server SQL - FALSE. PL/SQL = T-SQL - FALSE.

Just don't tell the recruiters.
Gift Peddie
Gift Peddie
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: 3452 Visits: 14456
Oracle secret weapon is VP Jim Melton who is ANSI SQL editor who edited the XML section in ANSI SQL 2006. That got me very worried because for political reasons Microsoft could just wait until the XML people finish the needed Algebra before implementing real XQuery which could be too late for SQL Server 2008. So for XML data intensive Web application you may still need to reach out and touch Data Direct who owns the XQuery url and sells an almost idiot proof albeit expensive tool.







Oracle does not sell developer edition of its RDBMS so for now it is like C.J.Date said do data as algebra and ask how is this implemented by Oracle.

Kind regards,
Gift Peddie
Rob-406527
Rob-406527
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 128
I like both but I do have to say that with enterprise class systems (8CPUs +) the scalability of SQL Server could become a problem. I would love to hear the experiences of others who have seen workloads from 40,000+ concurrent users.



From what I’ve seen with these larger systems you have to buy one big supercomputer and make sure to have extra slots for CPUs, memory, and additional fiber cards for scalability. With Oracle you just go the two midrange node RAC route and add one additional machine if you need to scale further.
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