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.

POST A COMMENT

17 Comments:

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).

A Dev DBA

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: http://en.wikipedia.org/wiki/In-N-Out_Burger_menu_items

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...
.

http://www.phrases.org.uk/meanings/119800.html

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

Thanks

Martin

Tue May 27, 05:27:00 AM EDT  

Blogger Thomas Kyte said....

@Martin

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.

Cheers

Martin

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 asktom.oracle.com 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?

Thanks!

Thu May 29, 03:03:00 PM EDT  

Blogger Thomas Kyte said....

@Anonymous

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
WHEN 'BUY' THEN COST
ELSE quantity
* SUM (COST) OVER (PARTITION BY NULL ORDER BY begtime, trade)
/ SUM (CASE positiontype
WHEN 'BUY' THEN quantity
END) OVER (PARTITION BY NULL ORDER BY begtime, trade)
END AS costwithwacogsale
FROM (SELECT begtime, trade, positiontype, CASE positiontype
WHEN 'BUY' THEN 1
ELSE -1
END * quantity AS quantity, CASE positiontype
WHEN 'BUY' THEN quantity * buyprice
END AS COST
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....

情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣,情趣,情趣,情趣,情趣,情趣,情趣用品,情趣用品,情趣,情趣,A片,A片,情色,A片,A片,情色,A片,A片,情趣用品,A片,情趣用品,A片,情趣用品,a片,情趣用品

A片,A片,AV女優,色情,成人,做愛,情色,AIO,視訊聊天室,SEX,聊天室,自拍,AV,情色,成人,情色,aio,sex,成人,情色

免費A片,美女視訊,情色交友,免費AV,色情網站,辣妹視訊,美女交友,色情影片,成人影片,成人網站,H漫,18成人,成人圖片,成人漫畫,情色網,日本A片,免費A片下載,性愛

情色文學,色情A片,A片下載,色情遊戲,色情影片,色情聊天室,情色電影,免費視訊,免費視訊聊天,免費視訊聊天室,一葉情貼圖片區,情色視訊,免費成人影片,視訊交友,視訊聊天,言情小說,愛情小說,AV片,A漫,AVDVD,情色論壇,視訊美女,AV成人網,成人交友,成人電影,成人貼圖,成人小說,成人文章,成人圖片區,成人遊戲,愛情公寓,情色貼圖,色情小說,情色小說,成人論壇

a片下載,線上a片,av女優,av,成人電影,成人,成人貼圖,成人交友,成人圖片,18成人,成人小說,成人圖片區,成人文章,成人影城,成人網站,自拍,尋夢園聊天室

A片,A片,A片下載,做愛,成人電影,.18成人,日本A片,情色小說,情色電影,成人影城,自拍,情色論壇,成人論壇,情色貼圖,情色,免費A片,成人,成人網站,成人圖片,AV女優,成人光碟,色情,色情影片,免費A片下載,SEX,AV,色情網站,本土自拍,性愛,成人影片,情色文學,成人文章,成人圖片區,成人貼圖

Wed Feb 04, 09:35:00 AM EST  

POST A COMMENT

<< Home