Viewing 15 posts - 18,376 through 18,390 (of 22,202 total)
Another vote for execution plans.
Check this article, [/url]and this one [/url]if you're new to them.
February 12, 2009 at 11:44 am
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...
February 12, 2009 at 11:41 am
GilaMonster (2/12/2009)
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...
February 12, 2009 at 11:18 am
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...
February 12, 2009 at 7:42 am
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....
February 12, 2009 at 6:57 am
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.
February 12, 2009 at 6:49 am
Roy Ernest (2/12/2009)
I like to help, but I am very very bad at explaining....
February 12, 2009 at 6:22 am
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.
February 12, 2009 at 6:19 am
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...
February 12, 2009 at 6:15 am
About the same as the way I feel about the "tax cuts" going to people who paid no taxes.
February 12, 2009 at 6:12 am
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...
February 12, 2009 at 6:11 am
I've been trying to stay away from this thread, but here's one:
February 12, 2009 at 6:07 am
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...
February 12, 2009 at 6:06 am
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...
February 12, 2009 at 6:00 am
Viewing 15 posts - 18,376 through 18,390 (of 22,202 total)