Viewing 15 posts - 11,101 through 11,115 (of 22,224 total)
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
SQL Packager is an option, but you could just build a batch command using SQLCMD.EXE. It won't be an executable, but a batch file will work the same way. Another...
"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:12 am
Hints are not what's needed. In fact, I'd drop the FAST(1000) hint to start with. That's going to generate a skewed execution plan if you're returning more than 1000 rows....
"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:07 am
sqlnaive (4/11/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 11, 2012 at 6:03 am
I haven't tried setting up an alert, but I have set up monitoring using some of the DMOs available. This Book Online entry lays out a bunch of the options.
"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 4:59 am
You down-graded from 2008 to 2005? You can't move the time column because they don't exist in 2005. You'll have to store it as a string, a varchar, or you'll...
"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 4:55 am
Too many guesses without seeing the actual code involved. In general, I don't recommend using a hint like RECOMPILE unless there's a driving reason for it. Do you know what...
"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 4:50 am
SQLRNNR (4/10/2012)
Grant Fritchey (4/10/2012)
Stefan Krzywicki (4/10/2012)
Jack Corbett (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/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 10, 2012 at 2:56 pm
Stefan Krzywicki (4/10/2012)
Jack Corbett (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/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 10, 2012 at 1:18 pm
mtassin (4/10/2012)
Not true... at least not from this example. The OP said that all 4 columns were nvarchar(20).
From the original bit of code I copied, it was a column...
"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 10, 2012 at 12:21 pm
marksquall (4/10/2012)
You two have mentioned something about cache. I have certain things to know abut this cache and I hope it 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 10, 2012 at 12:12 pm
Viewing 15 posts - 11,101 through 11,115 (of 22,224 total)