Saturday, August 4, 2012

Today I learnt something new in SQL Queries.. 
Thot I could share with you ppl!

I was running 
query a (select col1 from table1)>> execution time 3 secs
query b (select col1 from table2)>> execution time 5 secs
query a intersect query b 
(select col1 from table1 intersect select col1 from table2)>> execution time 16 mins!

Lot of technicalities and reasons are there for this behavior... but quick fix is as follows
select col1 from table1 where rownum>0
select col1 from table2 where rownum>0 >> execution time 6 secs!

Thursday, April 12, 2012

Sunday, January 8, 2012

If you are able to connect to a LAN but not to the Internet and if your network manager freaks you showing that you have Limited connectivity.

Here is the solution...

1. Use other static DNS

a. Click "Start" menu, type "ncpa.cpl" (without quotation marks) in Search Box and press "OK".
b. Select your local network.
c. Click Properties, then select Internet Protocol (TCP/IP).
d. Click Properties.
e. In the Internet Protocol window, let's change the "Preferred DNS server" to
f. Click 'OK' twice to complete the modification.

If the issue persists, please repeat the steps and change the "Preferred DNS server" to

2. Put the machine in another Wireless network and check whether it can access Internet normally. If so, I suggest you replace another encryption type for a test, such as WEP.

3. Reset WinSock

a. Click Start, click "All programs", and click "Accessories".
b. Right-click "Command Prompt", and click "Run as administrator". If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
c. Please enter the following command, and press Enter.

Netsh winsock reset

d. A message stating "Successfully reset the Winsock Catalog" will appear. Please restart the computer.


Sunday, December 4, 2011

I have not posted explicit hints. Its just a memoir on how I solved Klueless 7. It may still help you to reach the solution.

November 12, 2011.

I travelled to Coimbatore from Chennai and reached home at around 8:15 AM in the morning. After the usual routine at around 9:00 AM I logged in into the system and connected to Internet. As most people who use Internet do as soon as I connected into Internet I opened Facebook account. Once I opened Facebook, I got a ping from Hema (who was my Klueless 5 friend), Deepak are you not playing Klueless 7. OOPS! I had totally forgotten that Klueless 7 had been launched on 11/11/11, the date about which the whole media was going frenzy. Unlike K5 team who mailed me that K5 is on in a couple of days. These K7 team guys(gals too :P) didn’t mail me :@. Anyway that was history. I was in home and there is no other better place to play Klueless than home sweet home, that too on my desktop!

I informed my parents, I won’t be spending any time with them this weekend for I have to play Klueless.

Operation Klueless Starts…

Level 1:
K7’s home page helped me solve this level.

Level 2:
Having played Klueless and having built Cyber Cipher. Changing to the opposite took less than 10 seconds.

Level 3:
Reversing the answer which was right there in the middle of the page wasn’t much of a problem.

Level 4:
I used tineye to reverse search the image and the link I got there helped me to solve this level.

Level 5:
I found that all the characters in the image are related to Marvel characters. But it was a clue I found in blog that I need to look for a new movies to be released took me to past this level.

Level 6:
Having read Davinci Code and having written Mystic Murder, ROT 13 Solver helped me to go past this level. It’s quite a common phrase among web site designers.

Level 7:
“24”, this is the key. In Klueless 5, there are couple of levels with this Comics character. So this level too was easy.

Ha! The story takes a twist just when you think it is normal.

Level 8:
A simple level where I noted it was with the l, but spent nearly 3 hours going mad about the substitution. I was frustrated and took a break from the game. It was 5:00 PM. It was Hema who gave clarity in this IeveI.

Level 9:
Used ISBN calculator to solve the two ISBNs and get the answer. But if I took the source code literally this level would have been a much simpler one.

Level 10:
This big dipper wasn’t that tough. Going for the brightest one was obvious.

Level 11:
I was staring at the flower again and again but I couldn’t find what that flower was. Reverse searching too didn’t help. That’s when Hema’s 'pop' up came up in gtalk enquiring on my progress. She told me what the flower was. Then I had remembered about a day and it led me to a train, a treaty and finally a number which was the solution!

Level 12:
Over thinking will not help in this level. It was Victoria’s Secret and a ship which led me to a wiki page which had the solution in it. The url was stop ogling LOL :)

Level 13:
It was 7:00 PM. It was quite good progress, I guessed. Simple googling helped me to find about Romance Numbers and knowing about Fibonacci Series really helped solving this level.

Level 14:
I was rolling the dice 7 times for 7. Which was a problem again. I was over thinking. All that I had to do was watch the middle of the board.

I planned to take a break. Was dinner time. Resumed at 10:30 PM.

Level 14a:
It is same as 14. The only level in K7 which I thought was not necessary.

Level 14b:
Though it is a simple level. It was a very well thought out level. The connection between batman, Mr. Monopoly and the answer was simply superb.

Level 15:
Got the level’s answer from a Sudoku solver. But… but…but… the story doesn’t end there. I have never used Samsung Galaxy phone which uses the swype technology and that really cost me a lot of time. Hema helped me with the way to go about this level.

Level 16:
This level had a simple algorithm associated with it. Save the image > open in photoshop > Increase brightness/contrast >Answer would stare at you. It was a fairly simple level.
But it was calm before storm.

Level 17:
It was 11:00 PM. By this time Hema said she wouldn’t be playing further and left. Oh! Oh! This was THE MOST IRRITATING LEVEL in Klueless 7. I too slept off at November 13 1:00 AM.

Woke up at 7:45 AM. And started playing Klueless at 8:00 AM.
I needed 4 years which I found out after lot if googling. The sum of those 4 years was the solution.

Level 18:
If Q is A W is B the solution to this level is on the way. It was a breather after taunting level 17.

Level 19:
The Good, the Bad and the Ugly is not a movie that was unknown to me. Saying anything more would be like giving away the answer.

Level 20:
Ah! This was a well designed level. I had to find about sponge bob his death note and then the flags.Once I assembled them together, the answer was staring at me.

Level 21:
Good that I had the answers of the previous levels with me. This level was a cakewalk :)

Wanted to take a break. So was playing chess with my dad. Had lunch and then was matching India-Westindies test match.

It was 5:00 PM.

Level 22:
I loved playing this game. But they were looking for that game's scientific name :)
A very well thoughtout level.

I had leave to attened Karthika (Raj Kamal's sister) akka's reception. Came back at 10:30 PM.

Level 23:
Looking through the gaps and staring at screen pointlessly helped me solve this level.

Was feeling tired. Slept at 11:30 PM.

November 14,2011 08:00 AM. I woke up without any sense of urgency. And continued playing Klueless.

Level 24:
I had been playing golf ever since I got my new Wii Games. That helped me solved the level.

Level 25:
Ha!Another level on a batman villain! But this time around I needed to literally follow the title.

Level 26:
I know that K means 1000. Somehow I solved this level despite not knowing much about the doctor's translation sheet!

Level 27:
A girl is all that I need and yeah the game in this level is GTA!

By now it was 2:00 PM. I was watching India vs West Indies match for sometime.

Resumed klueless at 5:00 PM.

Level 28:
Next to level 17. This was the most taxing.
First I had to get the trip sheet. Then I had to find 7 stations and the sum of the prices from A to B, B to C et., helped me solve this level. The answer is a leap year which had 3 Friday the thirteenths!

Level 29:
Every one who is playing Klueless would surely know this answer.

It was 7:30 PM. I had to leave back to Chennai. Already I had applied one day leave to office, can't apply any more.

November 15, 07:00 AM. I came back to my room in Chennai and continued playing Klueless.

Level 30:
Here I had to work on Tron and find two colors. Then the ethernet cable connected to my system helped me solve this level.

It was 8:00 AM. I had to leave to office. Came back at 7:00 PM and resumed Klueless.

Level 31:
Atlast a level on cricket. I found this answer but was missing the space bewtween the two words :(

Level 32:
I had to be really patient. Then tin-eye helped me find this person.

Level 33:
I got the mail id from Daipayan Raja. I still don't know how he got that. Need to solve it sometime later.
Then it was a cakewalk.

Level 34:
I was almost exhausted solving this level before Daipayan threw some light. But a brilliant level. Don't want to give much leads on this :)

Level 35:
It is a lengthy level. Again Daipayan helped me solving the mystic.

Level 36:
There are 3 parts in this level. Relatively simple. Finally Klueless 7 was conquered at November 16,2011 12:30 AM.

Special thanks to Daipayan Raja and Klueless Hema :) especially Daipayan Raja who was with me from level 33 till the end. My name reached the Hall of Fame this time too, a fancy number this time around :-). It was 123rd position.

Game Link: Klueless 7

Now it would be an year wait for K8!

A taxi passenger tapped the driver on the shoulder to ask him a question.

The driver screamed, lost control of the car, nearly hit a bus, went up on the footpath, and stopped centimeters from a shop window.

For a second everything went quiet in the cab, and then the driver said:

"Look mate, don't ever do that again. You scared the daylights out of me!"

The passenger apologized and said, "I didn't realize that a little tap would scare you so much."

The driver replied, "Sorry, it's not really your fault. Today is my first day as a cab driver - I've been driving a van carrying dead Bodies for the last 25 years.......u can imagine what went into my mind when u touched my back!!

The world's largest model airport has opened at Miniatur Wunderland in Hamburg, Germany, which is also home to the world’s largest model railway landscape.

The model airport is based off of Hamburg's Fuhlsb├╝ttel International airport. It includes a whopping list of accessories, including 40 planes, 40,000 lights, 15,000 figurines, 500 cars, 10,000 trees, 50 trains, 1000 wagons, 100 signals, 200 switches and 300 buildings. The display took 7 years and roughly $4.8 million to build.

Ants Problem:
Ants hate cucumbers.
Keep the skin of cucumbers near the place or ant hole.

To get pure and clean ice :
Boil water first before freezing.

To make the mirror shine:
Clean with spirit

To remove chewing gum from clothes:
Keep the cloth in the freezer for an hour.

To whiten white clothes:
Soak white clothes in hot water with a slice of lemon for 10 minutes

To get maximum juice out of lemons :
Soak lemons in hot water for one hour, and then juice them.

To avoid smell of cabbage while cooking:
Keep a piece of bread on the cabbage in the vessel while cooking.

To avoid tears while cutting onions:
Chew gum.

To boil potatoes quickly:
Skin one potato from one side only before boiling.

To remove ink from clothes :
Put toothpaste on the ink spots generously and let it dry completely, then wash.

To skin sweet potatoes quickly :
Soak in cold water immediately after boiling.

To get rid of mice or rats :
Sprinkle black pepper in places where you find mice or rats.
They will run away.

There was a farmer who collected horses; he only needed one more breed to complete his collection. One day, he found out that his neighbor had the particular horse breed he needed. So, he constantly bothered his neighbor until he sold it to him. A month later, the horse became ill and he called the veterinarian, who said: - Well, your horse has a virus. He must take this medicine for three days. I'll come back on the 3rd day and if he's not better, we're going to have to put him down.

Nearby, the pig listened closely to their conversation.

The next day, they gave him the medicine and left. The pig approached the horse and said: Be strong, my friend. Get up or else they're going to put you to sleep!

On the second day, they gave him the medicine and left. The pig came back and said: Come on buddy, get up or else you're going to die! Come on, I'll help you get up. Let's go! One, two, three...

On the third day, they came to give him the medicine and the vet said: Unfortunately, we're going to have to put him down tomorrow. Otherwise, the virus might spread and infect the other horses.

After they left, the pig approached the horse and said: Listen pal, it's now or never! Get up, come on! Have courage! Come on! Get up! Get up! That's it, slowly! Great! Come on, one, two, three... Good, good. Now faster, come on.... Fantastic! Run, run more! Yes! Yay! Yes! You did it, you're a champion!!!

All of a sudden, the owner came back, saw the horse running in the field and began shouting: It's a miracle! My horse is cured. This deserves a party. Let's kill the pig!

Points for reflection: This often happens in the workplace. Nobody truly knows which employee actually deserves the merit of success, or who's actually contributing the necessary support to make things happen.


If anyone ever tells you that your work is unprofessional, remember: amateurs built the Ark and professionals built the Titanic.

Madan Mohan Malaviya was a freedom fighter, author, editor & publisher of newspapers, educationist, staunch Hindu. He is credited with popularising the slogan "Satymeva Jayate". He was the first one to establish a private university in India which is based on the model of historical Nalanda, Takasheela Vidya Peethams.

When Malaviya was trying to build a good university, he had to overcome many difficulties and barriers. He worked with determination to start the university. There was a funds crisis; but he did not get disheartened. He went from town to town, met many rich people and traders to collect donations.

He went to the Nizam of Hyderabad (then reputedly the richest man in the world) to request him for funds. The Nizam was furious, " How dare you come to me for funds and that too for a Hindu University? " He roared with anger, took off his footwear and flung it at Malaviya.

Malaviya picked up the footwear and left silently. He went directly to the market place and began to auction the footwear. As it was Nizam's footwear, many came forward to buy it. The bids kept going up.

When Nizam heard of this, he became uneasy. He thought it would be an insult if his footwear were to be bought by someone for a pittance. So he sent one of his attendants with the instruction, 'Buy that footwear no matter whatever the price be!'

Thus, Malaviya managed to sell the Nizam's own footwear back to him, for a huge amount. He used that money to build the Banaras Hindu University.

Moral of the story: It does not matter what you have, but how you make use of what you have, in your Life & Business.