Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Oracle being Netscaped? - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, MonoTouch for iPhone, MonoDroid for Android, and Windows Azure.

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

Oracle being Netscaped?

I read this article that some others have commented about.  I have worked with Oracle on several major projects.  In all of these projects, I have found 1 thing that Oracle does very well that Sql Server does not.  If I want to do a genealogy, it is very easy with Oracle to do a genealogy and find the parents / children of an entry.  It is not as easy to do this with Sql Server.  This is very helpful in a manufacturing environment when you might want to find out all of the input materials for an output product that is defective.  Given the fact that using Oracle within a MS environment has not been something that has caused headaches in the past, it is no wonder that MS is gaining marketshare.  Add to this the problem of knowing how to properly tune Oracle and the pain that that intales, and Sql Server looks better and better.

Comments

Frans Bouma said:

The statement, I don't remember the name, you refer to can be written as a user defined function in SqlServer, which is how Oracle has build it anyway.

Better is, to store parent-child relations in data differently. Joe Celko has written some articles about this in the Sql newsgroups
# June 1, 2003 10:14 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)