Viewing 15 posts - 11,086 through 11,100 (of 22,224 total)
If you're getting bad plans, it can still be because of the stats.
If the plans you're getting are working in an inconsistent manner, then recompile might not be the best...
"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 13, 2012 at 10:17 am
DBA_Dom (4/12/2012)
Grant Fritchey (4/12/2012)
"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 12, 2012 at 1:51 pm
Lynn Pettis (4/12/2012)
What would happen here on SSC if the TOP 25 posters did nothing but lurk for 24 hours?
Not much. There'd just be a few more unchallenged suggestions 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 12, 2012 at 11:40 am
pallavi.unde (4/12/2012)
Suppose i have one big query which is taking 20 minutes for execution, how could i...
"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 12, 2012 at 9:32 am
Oh lord, I think someone either has a homework panic (as seems to be standard around here) or is WAY over their heads at their job. They want me to...
"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 12, 2012 at 5:18 am
Again, I won't do it for you. If this is homework, you need to do it yourself. If you're getting paid for this, then you either need to pay me...
"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 12, 2012 at 5:15 am
Thinky Night (4/12/2012)
New questions:
If there is a mixed extent, Must it contain a Shared Global Allocation Map (SGAM) Page and Page Free Space (PFS) Page?
And
When a new extent...
"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 12, 2012 at 5:08 am
call.copse (4/12/2012)
"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 12, 2012 at 4:58 am
Seriously sounds like homework. If I do everything for you, do I get the grade?
I built the database used by the US Tennis Association back in the 90's (I've heard...
"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 12, 2012 at 4:53 am
If you're going to try to tune the query, you really need to get a look at the execution plan. That's a first step.
And to reinforce, NOLOCK is absolutely not...
"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 12, 2012 at 4:46 am
It's going to allocate an extent first then put pages there, but why does it matter?
"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 12, 2012 at 4:39 am
And just to reinforce what the others have said, read this blog post[/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 12, 2012 at 4:36 am
First, let's note, the DTA is notorious for offering bad advice, so be very careful in implementing it's suggestions. Test your stuff very carefully.
The best way to run the DTA...
"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 12, 2012 at 4:24 am
No, SQL Server 2012 itself is brand spanking new. It was just released last week. There aren't any updates yet. I'm talking about the client DLLs for connecting to SQL...
"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 11, 2012 at 7:34 am
Hmmm.... May be a driver issue on the web server? Hard to know. That looks like an error we used to get in 2008r2 that was related to bad drivers...
"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 11, 2012 at 7:23 am
Viewing 15 posts - 11,086 through 11,100 (of 22,224 total)