IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Comparing Oracle 10g and SQL Server Yukon
Post #184,508
by ChrisR
11/19/04 10:39:10 AM
Reply
New Comparing Oracle 10g and SQL Server Yukon
Thought the paper on [link|http://www.theserverside.com/news/thread.tss?thread_id=30067|Features, strengths, and weaknesses comparison between Microsoft SQL Server 2005 (Yukon) and Oracle 10g databases] might be of interest to some.

And while I'm linking to articles, might as well throw in [link|http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html|Slony for PostgreSQL] a database replicator project.
Post #184,710
by JayMehaffey
11/21/04 8:11:39 PM
Reply
New That reminds me
I need to curse on SQL server a bit.

I ran across a query this week that I had to optimize, because the report based on the query was taking too long. I'll admit it was a very ugly query, with a mix of sub queries and joins, against tables with non-existant or wrong headed indexes.

But I've really got some unpleasent things to say about a query optimizers where taking out a WHERE clause that said "tableA.ID = tableA.ID" resulted in a very different and less optimized query.

Jay
Post #184,738
by static
Picture of static
11/22/04 1:24:41 AM
Reply
New ICLRPD (new thread)
Created as new thread #184737 titled [link|/forums/render/content/show?contentid=184737|ICLRPD]

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please

-- "Anything but Ordinary" by Avril Lavigne.
     Comparing Oracle 10g and SQL Server Yukon - (ChrisR) - (2) - Nov. 19, 2004, 10:39:10 AM EST
         That reminds me - (JayMehaffey) - (1) - Nov. 21, 2004, 08:11:39 PM EST
             ICLRPD (new thread) - (static) - Nov. 22, 2004, 01:24:41 AM EST

You are delightfully evil. Come sit by me.
50 ms