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 18.104.22.168
f. Click 'OK' twice to complete the modification.
If the issue persists, please repeat the steps and change the "Preferred DNS server" to 22.214.171.124.
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.
Labels: Windows corner...
Sunday, December 4, 2011
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 :
To avoid tears while cutting onions:
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.
Labels: Short Stories (Others)
Labels: Deepak's Scribble