Bob Hovious (2/12/2009)

---

I tried to help him out with that one Grant. Maybe because it's early and I'm well rested. I read him as saying "I would...

I talk to myself all the time, to the horror of all my co-workers.

OK. You could try a query hint in this case, the OPTIMIZE FOR hint might help out....

But the key word and tricky phrase in that sentence was "during planned down time." I hear a question like this and I can sense my hackles going up.

Roy Ernest (2/12/2009)

---

That was a pretty good one. He gives the obvious answer and still ask the question.. 😀

I like to help, but I am very very bad at explaining....

You could post the execution plan & query to see if anyone can spot something. I'd do that in a seperate post though so you get more eyeballs.

Ah. OK. Good answer. 😀

Yeah, I'm going to pile on with Lowell here. Running a check every 30 seconds and updating a status does what exactly that simply writing the same check into a...

About the same as the way I feel about the "tax cuts" going to people who paid no taxes.

I don't have all the answers to your question, but I can advise you to look in a slightly different direction. LINQ is being swallowed up the Entity Framework. That's...

I've been trying to stay away from this thread, but here's one:

http://www.sqlservercentral.com/Forums/FindPost655416.aspx

I'm sorry, but you can't create temporary tables in CE. Since you know this, why are you asking the question?

BTW, you can nest queries in 3.5 & above, does that...

No, you can't. You can execute the proc and get a result set within another proc:

EXEC spGetCarList @Parm1 = '42'

You could insert the output of the procedure into a temp...

You might not want to go down that road, and I don't blame you, but you might have to. Are you doing full scans on the statistics or just using...

Why would you want to do something like that?

Follow Stephen's advice. Use the MAX data type and keep working with sp_executesql if you have to do dynamic queries.