Viewing 15 posts - 17,656 through 17,670 (of 22,202 total)
I'm not sure I understand the question. Are you trying to tune queries where there is a lot NULL columns?
If so, yes, this can be an issue in 2005 and...
April 20, 2009 at 6:19 am
Bruce W Cassidy (4/19/2009)
Florian Reischl (4/18/2009)
What do you like more C# or VB.Net?
[font="Verdana"]For me personally I prefer C#. But you will probably find there's a bigger audience for VB....
April 19, 2009 at 5:03 pm
It honestly depends on what the optimizer considers to be a trivial plan. Here's an explanation of how plans are determined: http://msdn.microsoft.com/en-us/library/aa226174.aspx
April 18, 2009 at 4:53 am
Lynn Pettis (4/17/2009)
But sometimes you just have to get in there and beat some heads with that quarter staff. It ain't just for walking you know.
I actually missed that...
April 18, 2009 at 4:48 am
Jack Corbett (4/17/2009)
Lynn Pettis (4/17/2009)
But sometimes you just have to get in there and beat some heads with that quarter staff. It ain't just for walking you know.
Which is...
April 18, 2009 at 4:45 am
You can try joing to dm_exec_plan_attributes and see if the user_id is available for the plans you're interested in. It might not be.
April 17, 2009 at 11:43 am
It broke 60 here in the Peoples Republic. Looking good for camping this weekend (although it's going into the 30's over night). I'll be sleeping comfortably in my Hennessy Hammock[/url]...
April 17, 2009 at 11:39 am
Not a trigger for monitoring, use a server-side trace.
April 17, 2009 at 11:23 am
I'd suggest looking into the waits & queues. Use this white paper from MS.
April 17, 2009 at 8:38 am
I completely glossed over the test instance thing on the first read. Yeah, that's a bad idea. You can seriously mess up your environment that way. Testing and development should...
April 17, 2009 at 7:22 am
Parallelism, no. Memory yes.
There has to be a difference somewhere. Are they on the same service pack and hot fix #?
April 17, 2009 at 7:16 am
If it's considered a trivial execution plan, it won't cache the plan that's created. That looks like a plan that is likely trivial.
BTW, you're posting in the 2008 area for...
April 17, 2009 at 7:03 am
If you have multiple plan handles, have you looked at the plans? For the same query, you'll get two plans when parallelism is invoked.
April 17, 2009 at 7:00 am
What about the parameters?
Does one of the servers have a different parallelism threshold than the other? How about the parallelism setting? ANSI connection settings? Um, memory allocations, any other kinds...
April 17, 2009 at 6:58 am
If I understand the question, you can this to your code
...
--Previous parts of a procedure
SET STATISTICS IO ON;
EXEC something;
SET STATISTICS IO OFF;
--The rest of the procedure
...
April 17, 2009 at 6:49 am
Viewing 15 posts - 17,656 through 17,670 (of 22,202 total)