The Sql Query Tips

Query writing is art and it should be optimized. You will be worried about your sql query while handling millions of data. Here is the list should be avoided


1. Avoid using Not like,<>,Not IN
    Not will always takes a huge query cost and it should be avoided in most cases.

2.Avoid using data conversion in where clause
   ex: Where Convert(Varchar(25),country)=@country

3.Avoid using function call in where clause
   ex:where country IN (dbo.getcountry(@country,'' , "))

4.Don't use SQL function (Max,Min,Sum) in sub query. it will eat time.

5.Avoid memory tabes (@temp),use temporary table (#temp)


List goes i will update whenever possible

My Vacation

Vacation is bit hard to start with. but in the end .it bit hard to leave it.In the journey of life with carrier .vacation is vital for every one to refresh. its beginning of new innovation.

I started with kodaikanal stayed alone for three days .its bit disappointment to stay alone. i didn't expect i will be alone. due to lack of time my friends joined me after three days . I know if you are alone you will realize your self.In same way i learned a lot when i am alone.

After three days stay and two days stay in relative house . i joined my friends and we went to munnar at day one and traveled lot in hill stations.Its nice place to go with. We traveled in forest and could see animals. if we stopped car . it will kill us. The temperature is around 22- 26. Good to have night stay there and went to allepy (Backwater ).We traveled in boathouse for three hours and saw different dimension of life style. The people here using boat to travel. they have government boat instead of bus. More work for my dig camera. We went to church,palace...

Finally we reached TVM this is place we started last year. we stayed in same hotel. nice memories to recap. Finally reached home and went to office Monday. Its hard time to check 10 k mails and lot of pending works.More than two days i don't like to work.But i feel lot more to go...

This is my first blog after a long gap. going to write share my experience with web,designing,sql and pets.