RE: Re[2]: SQL Server vs. Oracle

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 12 May 2004 23:00:19 -0500
Message-ID: <000c01c4389e$d1a5aaa0$6601a8c0@CVMLAP02>

That '+' sign really makes the sentence quite a bit more flexible, = doesn't
it! :) It's one of those "true but worthless" statements that I talked = about
at IOUG.

Other examples include...

• The haircut places that offer haircuts at "$15 and up." "The bill's = $45? Hey, we said 'and up.'"
• I think I know a place where I could buy a 2004 Porsche 911 Turbo with = 2.7 miles on it for $25+.
• Consultants who promise that increasing your database buffer cache hit ratio can yield gains of over 400%. "Can." Not "will." :)

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 5/18 Edison NJ, 6/22 Pittsburgh, 7/20 =
Boston
- SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver

• Hotsos Symposium 2005: March 6-10 Dallas
• Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jonathan Gennick
Sent: Wednesday, May 12, 2004 8:11 PM
To: Niall Litchfield
Subject: Re[2]: SQL Server vs. Oracle

Wednesday, May 12, 2004, 10:45:29 AM, Niall Litchfield (n-litchfield_at_audit-commission.gov.uk) wrote:

NL> <quote> For Microsoft SQL Server 2000, the process of
NL> tuning a poorly performing complex SQL Statement is
NL> mostly manual (index tuning being the only exception);
NL> therefore, given the fact that this task will almost
NL> always take a significant and variable period of time,
NL> we feel that 10+ minutes is a fair, conservative
NL> estimate of how long it would take an expert performance
NL> engineer

10 minutes? Only 10 minutes? Wow. I guess I must be far from being an expert then, because I don't know that I've ever solved a real-life SQL performance problem in only 10 minutes. Heck,

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by=20 email. To join, visit
http://five.pairlist.net/mailman/listinfo/oracle-article,=20 or send email to Oracle-article-request_at_gennick.com and=20 include the word "subscribe" in either the subject or body.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 12 2004 - 22:57:55 CDT