Wildcat (5/2/2012)

---

As others mentioned, we can only guess.

From your query, why you use "UNION" and "DISTINCT" at the same time? You can use "UNION ALL" and "DISTINCT". It may save...

Wildcat (5/2/2012)

---

As others mentioned, we can only guess.

From your query, why you use "UNION" and "DISTINCT" at the same time? You can use "UNION ALL" and "DISTINCT". It may save...

Indeed it does. Actual is 0...

There has to be something that sql agent is doing or isn't doing that would cause a different query plan to be generated.

Lynn Pettis (5/2/2012)

---

The problem here is that we can't see what you see. What little you have provided only allows us to take wild shots in the dark and...

Thomas Stringer (5/2/2012)

---

Could be a result of bad parameter sniffing. Without more information as to what the stored procedure does, the calls that are made to it (i.e. parameters),...

No, not Red Gate.

There's not 1 stored procedure in the whole database either. NADA. There are a bunch of unused indexes though:-)

GSquared (12/28/2011)

---

If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt they could get....

Dev (12/28/2011)

---

Poor design of database, probably...

It seems to me that the need to send 2000+ parameters for an "IN" clause is the symptom of a poor design.

Ninja's_RGR'us (12/23/2011)

---

ben.rosato (12/23/2011)

---

Ninja's_RGR'us (12/23/2011)

---

I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.

The compile...

Ninja's_RGR'us (12/23/2011)

---

I don't know that vendor, but I'd be curious as to know why this is running slow. This shouldn't be hard / long to run.

The compile time might...

I'll...

Never heard of such a requirement.