Grant Fritchey (1/25/2013)

---

sqlnaive (1/25/2013)

---

Grant, in addition to this, does it means just declaring internal parameters won't resolve parameter snififng ? Is updating stats mandatory (I know there's always "as per...

Grant, in addition to this, does it means just declaring internal parameters won't resolve parameter snififng ? Is updating stats mandatory (I know there's always "as per situation" criteria but...

Radu Costescu (1/25/2013)

---

If I execute this s/p, either from calling application code, or from Query Analyzer (exec ...), it take very much time to execute (1.5 - 2 hours). ...

It was a basic but very good question. I was in little confusion over the second value but when concentrated, got it right and earned 1 point. 🙂

Nice question. 🙂

Cool. Thanks. I was trying this by creating temp table and then making CROSS JOIN. But definitely it's better. 🙂

Good question. Took some time as I get confused in between generating query plan within my mind from these slight confusing queries but finally did it. 🙂

Fortunately or unfortunately, it is the same table. That was also in my mind. But I don't understand that how it is not giving any issue currently as it is...

Thanks. Apart from drivers, how it works parallely ? Say If i create a SSIS package. Will the same package work in parallel if invoked with different set of parameters...

Good question brushin up your skills. 🙂

Great question. I needed to know. Lost a point but worth the knowledge.

Thanks a lot for this question. Got to know about CHOOSE function. Very helpful. 🙂

Good question. Read all the options and with each option my answer changed and finally got the right one.

Very Easy. 🙂

I agree with both Andre and Dineshbabu. Was looking...