Friday, May 23, 2008

Hear, Hear

Double, double...


Been a while since I've pointed to his blog - but this one is one that resonated with me.

I related to it for this reason:  when people describe what problems they are facing in technology - they very often assume the person they are describing it to have the same background, nomenclature, experiences.  What they forget is we don't work with them, we don't share the same jargon and most importantly - we haven't been staring at the problem like they have for the last 5 days - it is all new to us.  And therefore, we need lots of detail. 

For me, this manifests itself in a question like this: I have this/these table(s).  I need a report that looks like this: .... This query is failing.  Please correct it.

It won't matter how loud or long they say "Please correct it", it won't happen - we don't know what the question is yet!

Double, double - indeed.



Anonymous Anonymous said....

same issue when talking with Sql Server DBAs ( I am mainly Oracle), they keep thinking that if they repeat their rebuild indexes mantra at me, I'll get it. I actually had to read a book that described page splitting when an index page fills up to understand what they were talking about.

Fri May 23, 11:47:00 AM EDT  

Anonymous Amardeep Sidhu said....

True !!!

It happens everywhere...people have those images in their minds and they keep on describing it without realizing if you are getting any bit of it...

Fri May 23, 12:06:00 PM EDT  

Anonymous Mette said....


Yes, please keep that "double double" in mind, when DBAish people in here ofte "yell" at "stupid" developers who use "when others", triggers etc.

If we are just beein yelled at or worse laughed at - and not beein told how to actually do it in another (better) way - then what's the point?

If noone told us, we are not told at Oracle courses - and the DBA's just herass and/or laugh ..... sigh ...

We need to bring the two parts closer - we actually work towards the same goal (I assume - and hope).


Fri May 23, 04:31:00 PM EDT  

Anonymous Anonymous said....

Hey! It's not just tech. folks. Remember the old bit about Americans when they travel abroad. If they just say it slow enough and loud enough, everyone can understand their english.

Fri May 23, 06:01:00 PM EDT  

Blogger Joel Garry said....

Google knew right away:

word: hanufoz

Sat May 24, 12:29:00 AM EDT  

Blogger William Robertson said....

This comment has been removed by the author.

Sat May 24, 07:47:00 PM EDT  

Anonymous Michael Olin said....

Google may have found it, but you still have to know the context to find the right reference. Google's top link is to Wikipedia (as Joel found above), but there are several "Double-Double"s referenced there:

For the binary star system, see Epsilon Lyrae
"Double-Double" is also In-N-Out Burger's name for its double cheeseburgers.
"Double-Double" is also a colloquial term in Canada for Tim Hortons coffee with two creams and two sugars
A double-double is a basketball term, defined as an individual performance in a game in which a player accumulates a double digit number in any two of these categories: points, rebounds, assists, steals, and blocked shots. The most common double-double is a combination of points and rebounds, and then next is points and assists.

The main Wikipedia article is about basketball (wrong context, not our "double-double"). The first alternate reference is astronomical (nope). Next is the In-N-Out Burger reference that Joel posted (closer, we're talking food, but still not it). Finally, we get to coffee (as Seth mentioned in the original post that Tom referenced).

Context is king (unless we're all Canadians)!

Sun May 25, 05:16:00 PM EDT  

Anonymous Doki-Chan said....

...or from anyone who can remember their Shakespeare's Macbeth:

"Double, double toil and trouble, fire burn, and cauldron bubble..."

considering the post title has a comma in it and not a hyphen...

but I must confess that I myself can write a spec and get bogged down in "Tech-ese" sometimes... I do find it difficult to tread the fine line between being technically incomprehensible and being seen as condescending because it feels like I'm "dumbing it down" so the helpdesk staff can understand and pass on what the new change will physically do to the users....

Tue May 27, 03:32:00 AM EDT  

Anonymous Martin said....

Tom - sorry completely off topic, but wondering what laptop you are using these days?
I need to buy one and will be using it primarily for Oracle stuff - personal edition etc so interested to know what you use



Tue May 27, 05:27:00 AM EDT  

Blogger Thomas Kyte said....


I am still using this one, from two years ago.

I would buy it again - probably will sometime this summer - with more memory and dual core....

Tue May 27, 06:19:00 AM EDT  

Anonymous Martin said....

Thanks Tom. I'm between a Sony Vaio and a Dell Insprion. Can get more for my money with Dell but know of lots of people who swear by Sony so trying to weigh it up.



Tue May 27, 10:03:00 AM EDT  

Anonymous Anonymous said....

> I'm between a Sony Vaio and a Dell Insprion.

LOL, I love how people come here asking about buying laptops (not there's anything wrong with that)

Tue May 27, 12:04:00 PM EDT  

Anonymous Anonymous said....

Tom, another off-topic question. I posted a question on today and, afterwards, realized that I had incendentially deleted a critical formula in the query. How should I go about re-stating my question before you get a chance to rip into me about posting a poor question?


Thu May 29, 03:03:00 PM EDT  

Blogger Thomas Kyte said....


well, since you posted here anonymously - I have no idea what question might have been yours - so....

You'll just have to wait and see what I have to say.

Thu May 29, 03:11:00 PM EDT  

Anonymous Anonymous said....

Fair enough . . . I guess I assumed this was not necessarily the avenue and you might direct me to that place.

Since this apparently is, this is Ryan from Indianapolis and I posted a question entitled "Recursive Analytics Weighted Average Cost Calculation"

The second code block should be replaced with this:

SELECT begtime, trade, positiontype, quantity, COST, costwithwacogsale,
SUM (costwithwacogsale) OVER (PARTITION BY NULL ORDER BY begtime, trade) AS rollingcost, rollingqty,
(SUM (costwithwacogsale) OVER (PARTITION BY NULL ORDER BY begtime, trade)) / rollingqty AS wrongwacogagain
FROM (SELECT begtime, trade, positiontype, quantity, COST, SUM (quantity) OVER (PARTITION BY NULL ORDER BY begtime, trade) AS rollingqty,
CASE positiontype
ELSE quantity
/ SUM (CASE positiontype
WHEN 'BUY' THEN quantity
END AS costwithwacogsale
FROM (SELECT begtime, trade, positiontype, CASE positiontype
END * quantity AS quantity, CASE positiontype
WHEN 'BUY' THEN quantity * buyprice
FROM wacogcalcdata))
ORDER BY 1, 2;

I was trying to clean up unused calculations and only cleared out half of one, leaving a jibberish-based calculation for the post.

Thanks again.

Thu May 29, 03:18:00 PM EDT  

Anonymous Anonymous said....

In a big originization I find there are a couple of reasons.

The person whose been working on the issue:
* is so busy does not have time to write much.
* most do not answer email with a real answer so why take the time to write one full of detail.
* is really clueless
* afraid about giving away some corporate secret
* afraid all will know the person is clueless

Sun Jun 01, 06:56:00 PM EDT  

Blogger sexy said....







Wed Feb 04, 09:35:00 AM EST  


<< Home