Viewing 15 posts - 18,391 through 18,405 (of 22,214 total)
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
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...
February 12, 2009 at 5:57 am
Why would you want to do something like that?
February 12, 2009 at 5:50 am
Follow Stephen's advice. Use the MAX data type and keep working with sp_executesql if you have to do dynamic queries.
February 12, 2009 at 5:44 am
Viewing 15 posts - 18,391 through 18,405 (of 22,214 total)