Another vote for execution plans.

Check this article, [/url]and this one [/url]if you're new to them.

If performance has been degrading over time, in addition to doing what Jack suggests, you should update the statistics, probably with a full scan, and set up a schedule to...

GilaMonster (2/12/2009)

---

Eeep..

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

I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?

Gees, it took me months of reading to decide on an appropriate...

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...