Archive for April 2007

The day Murphy come

WARNING: Full of technical terms.

Or rather, I tried to reduce the technical terms. But I seems like instead of making it easier to understand, I made it harder to understand. Oh well…. Just take it as another DK’s ranting.


There was a major error in office today.

Usually, it is ok for us to omit certain field in our SQL selection. That field is not really required if we run the sql script in the correct server. Keyword “IF”.

So what happen on Thursday was that someone raised a datapatch and omit that field. And the coordinator made an error and run the script on the wrong server, thus causing wrong rolls to be updated.

Before you start point your finger at PITA, I would like to say is, this is not done by PITA. He did have some involvement actually. He suggested adding an additional field in the SQL query. And by chance, that field actually reduced the number of roll that are wrongly updated. The thing I was wondering is… why didn’t he advice them to add another field which will totally prevent error from happening even if someone run in the wrong server. Oh well…. whatever.

Can’t really blame whose fault. Everyone’s action, if by itself, will not cause an error. It is only when everything combine together and all the conditions are right will it cause an error. I blame Murphy for visiting us. I’m still amazed by how everything fit into the puzzle so nicely that it causes an error. Rightfully it shouldn’t cause an error at all. It seems that all the condition are just nice to create this error.

I guess we all have to be more careful. Murphy will strike anywhere, anytime….


I was rushing to fix the error. To speed up my job, I asked a colleague from another team to help me do an extraction. I gave her 20,000 number and ask her to help extract the records. But she only came back with 1000plus records found. One look and I know something is wrong.

If she gave me 19,000plus records, I can still understand cause not all the numbers will have a record in the database. But 1000 plus is confirm wrong. So I took a look at her SQL query…… HOW the heck did that query run in the first place? She put all the 20k number in a single ‘in’ statement!!

I can’t remember is it oracle can only support 1000 rows in a ‘in’ statement or the performance of the SQL will drop if exceed 1000 rows. But confirm her method won’t work. And I wonder how she managed to get 1000 plus records returned.

Put all 20,000 number in 1 ‘in’ statement? If so easy, I would have done it myself lor.

Instead of asking her to re-do, I did the extraction myself. Insert the 20,000 numbers in a temp table first and use the in statement to refer to the temp table. I guess it would be faster than asking her to re-do the extraction.

Oh, and it is not PITA this time.

The irony about the whole thing is, she just went for a SQL performance tuning course last week. What a waste of money. Should send me to that course instead.

"Face on table" Meme

I don’t know why so many people interested in my “face on table” picture in my blog profile. I even have to put my face on the table during meetup to proof to them that I’m really DK. Haha.

Just some background info about that picture. It was taken in my school library. I was doing my revision for my exams. And I was so bored that that started playing with my handphone camera. And there you have it, the famous DK’s “Face on table” picture. :D

Anyway, Rinaz did a “face on table” on her tumblr today. Hendri followed by posting a “face on table” shot in his flickr. Hmmm…. am I starting a cult here?


OK, I’ve decided to start a “face on table” Meme. It’s very simple.
Post a picture of your face on the table and tag another 5 people to do it. Be creative. Try different pose.

Here is my classic “face on table” picture.

I tag:-
East Coast Life
Cobalt Paladin

Wait…. I should tag more people since I’m the Meme starter. So I also tag

And anyone who wants to play can also do this meme. :D
Lets have fun putting our face on the table.

UPDATE: I’ve decided to issue a health warning.

MORE UPDATES: OK, I know face on table is quite boring and limited. So some of you guys suggested “face on anything”. Well, go ahead. Let your creativity juice flow. :)

Nicole did a great “Face on *Insert object name*” picture. :)

I’ve started a thread in forum for everyone to post their picture. :)

I can’t list everyone’s name here. I hope everyone will come have some fun and do this meme. Come come… Join in this meme….. Don’t shy. :D


This is fun. 打小人. Very useful when PITA do his stuff again.

I say first hor, don’t beat me lah.

Who is reading my blog?

I always wonder… who is reading my blog?

I know its impossible to keep my blog a secret. I got up to 100 plus hit per day. Bound to have someone I know who bump into my blog. OK, maybe some might not recongise me since my face is on the table. But bound to have some who know its me by reading the things I write. I won’t be surprised.

I’m actually fine with people who know me personally reading my blog. But then, I always wished that they would tell me that they are reading my blog, rather than secretly reading it behind.

Just got to know that one of my colleague also know my blog URL. She said someone emailed to her last time, but she forgotten who is it. Hmmm…..

Anyway, I would really hope those who know me personally will let me know if they are reading my blog. Well, at least I’ll control myself and not write bad things about them in my blog. :P

I’m back

Hello running route. Long time no see.

It’s good to be back. Now I need to get my momentum going.