Viewing 15 posts - 17,671 through 17,685 (of 22,219 total)
Yes, you can follow the link provided above and download the book for free. It's also available in a dead-tree version from Amazon if you prefer reading from paper.
Also, you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 20, 2009 at 6:31 am
Parallelism is an expensive process because of all the management that SQL Server has to do. So, you only want it to run on queries that are running long already...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 20, 2009 at 6:26 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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]...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 17, 2009 at 11:39 am
Not a trigger for monitoring, use a server-side trace.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 17, 2009 at 11:23 am
I'd suggest looking into the waits & queues. Use this white paper from MS.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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 #?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 17, 2009 at 7:00 am
Viewing 15 posts - 17,671 through 17,685 (of 22,219 total)