Yep. In the properties. And yes, it needs to go in my book. That's one of the MANY things that are going to get added in the rewrite.

Oops. I spend most of my time in 2008 these days. I tend to bleed that stuff back down the chain sometimes.

There are a few ways. You can modify the proc to include WITH RECOMPILE as a hint, I don't suggest that though. Another way is to get the plan handle...

Right out of the gate, you've got a DISTINCT and a GROUP BY. That's an aggregate operation on an aggregate operation. I'd try to eliminate the DISTINCT from the query.

Looking...

I very strongly recommend you get a copy of Don Jones book, PowerShell 2.0 TFM. It doesn't get into SQL Server much at all, but it will give a very...

Excellent article. Clearly articulated and great examples. Thanks.

It's describing the amount of memory used to store temporary row data for sorts & other operations. Here's a great blog entry from MS on it.

It sounds like a parameter sniffing issue. A quick fix would be to recompile the procedure on prod and see if the plan changes.

Jeff Moden (10/21/2010)

---

Grant Fritchey (10/20/2010)

---

Jeff Moden (10/20/2010)

---

Paul White NZ (10/20/2010)

---

GSquared (10/20/2010)

---

I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of...

Jeff Moden (10/20/2010)

---

Paul White NZ (10/20/2010)

---

GSquared (10/20/2010)

---

I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a...

LutzM (10/20/2010)

---

Is it just because I'm in a bad mood today or why do I have the feeling that todays questions are more demanding with even less effort than on...

Or, would it be

SELECT * FROM TABLE WHERE SK = 1 AND Flag = 1I'm confused too.

Please don't post to multiple locations. It just messes up the conversation.

There are also responses over here.

What are you trying to do?

Simply debugging the procedure, which means validating that it runs correctly and does what is requested of it, just requires access to the database and...

Oh, and start learning PowerShell. I'd start with Don Jones book, PowerShell 2.0, TFM.