Could you show us what you have done so far to resovle this problem yourself? It may be a simple fix to your code.

Count physical processors, not the number of cores in each physical processor.

Actually, Grant, I'm curious also, and with your experience with working with execution plans, your feedback on that side would be quite interesting.

Grant Fritchey (1/27/2009)

---

Uh... Wow... Over-achieve much?

I feel a bit stupid to be commenting on this. I don't have much experience with partitioning beyond reading up on the theory and a...

Okay Gurus, time for a shameless plug. How about getting out there and reading my article. You're the ones I would really like some feedback from regarding the...

Not sure, but I think this article may help, give it a read and see if it helps: http://www.sqlservercentral.com/articles/T-SQL/63003/

The problem is here:

"Subquery

returned more than 1 value. This is not permitted when the subquery follows

=, !=, = or when the subquery is used as an expression."....

DHeath (1/27/2009)

---

So my question is this..if you have 64Bit MSSQL Ent Edition why would you need AWE if you are running with 64Bit Ent Edition OS. Considering that the...

Grant Fritchey (1/27/2009)

---

Steve Jones - Editor (1/27/2009)

---

Grant, that was a cheap post, course, I probably have a few as well.

Lynn has a good point. Writing coherently, even giving someone a...

David Jackson (1/27/2009)

---

Lynn Pettis (1/27/2009)

---

I am sure this is in response to the following:

I received a private message...

GilaMonster (1/27/2009)

---

Bob Hovious (1/27/2009)

---

One more post towards 1000.... and close to the original topic here. How many people get annoyed by people who cut and paste data rather...

If the OP's provide us with the information we request (how many times have we as a group pointed OP's to Jeff's article), we usually provide back tested solutions. ...

I'll have to check those out from home. Unfortunately most blog sites get blocked here at work.

Hey, occasionally, yes in character I must be.

For the most part, when actually getting into a discussion with others, I try...

I am sure this is in response to the following:

I received a private message with a question regarding...