Saturday, August 4, 2012

SQL Query Intersect.. Solution


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
intersect 
select col1 from table2 where rownum>0 >> execution time 6 secs!

Sunday, January 8, 2012

Limited Connectivity Problem Solved

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 208.67.222.222
f. Click 'OK' twice to complete the modification.

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

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.

Source: http://social.technet.microsoft.com/Forums/en-US/w7itpronetworking/thread/a849e5f7-e770-4ff1-b58b-7414797980db/