Can't say without seing the code.

So when you ran the proc with profiler on did you see the recompile?

Did you try both version and again compare the perf in profiler?

Don't know, there seem to...

I love the new question style Ron! Nice way to do this :cool:.

Guy missing 60 cpus! Don't know how to help.

http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx

SQLSeTTeR (11/15/2011)

---

I want SQL server 2008 to see all 80 CPU's the same way SQL sever 2008 R2 is. My apologies if I was not clear. Thank you for...

Back to square 1. What is the specific problem you are trying to...

Search for CSS text align. I don't remember right now.

You don't need a cursor for this. Look again at how Lowell's doing it. There's a way to...

Stop playing with indexes. Your problem is likely that you are missing information about the keys of that join. My guess is that you need to have 1-2...

No I meant maybe it's NOT activated on the 1 missing cpus. (Check Bios too).

Don't know, never had that issue nor read about it aside from the hyperthreading issue.

You messed up somewhere in the copy / paste.

You could always try to use [server name or ip] instead of using quotes. Maybe that's the difference here.

Welsh Corgi (11/14/2011)

---

Ninja's_RGR'us (11/14/2011)

---

SSRS + subscriptions could work if you have enterprise.

If not send an html e-mail and use code to calculate the correct headers for the code and you'll...

Sorry, no.

petervdkerk (11/14/2011)

---

it was more that I left the room (because of my previous script I thought I had all the time ;), so I knew it was less than a...

Michael Valentine Jones (11/14/2011)

---

Maybe the hidden code is:

waitfor delay...