Monthly Archives: April 2016

Getting all values when input parameter is NULL and still get IX seek behavior!!

By | April 17, 2016

Recently while working on a requirement for a client we came across this scenario. It’s fairly widely used although I would not recommend it. The example is in very simple terms explained below:- SEEK SCAN   If you look at the above query you will see that when the @int parameter has a value we… Read More »

Waging war against India Standard Time

By | April 14, 2016

If you’re an Indian you already know what I mean when I say India Standard Time. It’s the unique time zone that adds an additional 30 min to 1 hour to any time that was previously agreed upon. This UIST (unofficial IST) has been a part of Indian life since childhood. Waiting for buses that… Read More »