Viewing 15 posts - 11,086 through 11,100 (of 22,219 total)
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
If it has been recompiled, you're getting the new plan. That's what gets stored in cache.
"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:06 am
Lowell (4/11/2012)
returning 4.9 million rows will...
"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:04 am
Not seeing where the $NewSales is coming from, maybe that's it. It's the values passed or the WHERE clause. One or the other. The T-SQL syntax looks proper.
"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:01 am
I can't see how the $Variables are being generated within the code, but the basic UPDATE syntax looks right. So what do you mean by "does not work"?
"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 6:21 am
Hard to know without a lot more information. That general error type has been around forever. It's not unique to 2012. Do you have other information? Is it happening at...
"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 6:17 am
Viewing 15 posts - 11,086 through 11,100 (of 22,219 total)