Fal (10/19/2011)

---

What? Just one night? I'm gone for a couple of days and come back to find the thread dominated by...

mwagner 55444 (10/19/2011)

---

That is the exactly the problem, I've got something...

It looks to be a need to End the Conversation (service broker).

Check this thread and see what they did.

http://serverfault.com/questions/235327/mssql-2008r2-service-broker-initiator-queue-filled-with-old-conversations

mwagner 55444 (10/19/2011)

---

I think this may have helped:

sysdercv ...

Sometimes that little bit of extra info is enough to tell the optimizer a better plan to choose. That appears to be the case here. Posting the execution...

Ninja's_RGR'us (10/19/2011)

---

Ninja's_RGR'us (10/19/2011)

---

SQLRNNR (10/19/2011)

---

Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you...

Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you mentioned)

http://jasonbrimhall.info/2010/05/25/space-used/

Ninja's_RGR'us (10/19/2011)

---

SQLRNNR (10/19/2011)

---

Ninja's_RGR'us (10/19/2011)

---

Yes, you actually stole a quote I had...

Steve Jones - SSC Editor (10/19/2011)

---

Hey, I like Harold and Kumar. They entertain...

Ninja's_RGR'us (10/19/2011)

---

Yes, you actually stole a quote I had posted 20...

Somebody stole your ring err pants?:-D

Remi blacked out his phone number so we couldn't pants him.

Ray K (10/19/2011)

---

I thought about it, but I figured that it was already going on The Thread. No need...

Is that what your five finger reference meant?

as in CV?