Viewing 15 posts - 16,276 through 16,290 (of 22,219 total)
I'm not sure. I've never run into that particular error and there's very little documentation around it.
"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
October 21, 2009 at 7:52 am
That's a very odd error. I did a search on the web and this was the best that I saw.
So I went over to MSDN and found something more useful....
"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
October 21, 2009 at 7:40 am
Without a baseline on the old system, you can't possibly see if performance improved.
All you can do now is baseline the new system (baseline means collect a set of performance...
"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
October 21, 2009 at 6:48 am
That's a fright all right.
I didn't even read through it all, but at the end I saw this and started laughing
ORDER BY Right([Queue_des_echantillons].[Noechantillon],5)
So much for using an index.
"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
October 21, 2009 at 6:45 am
I absolutely recommend going to a file and then importing to the database. It's just cleaner and easier.
However, depending on the counters you're interested in, you can get them from...
"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
October 21, 2009 at 6:42 am
endeavour (10/19/2009)
Rather than my describing a single theoretical context,
has anyone actualy hired a consultant to advise on...
"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
October 21, 2009 at 6:38 am
Yes.
Even if you have talent in-house for tuning performance, you might need to bring in outside help if you're busy or, worst of all, when management doesn't trust that you're...
"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
October 21, 2009 at 6:32 am
The cost values displayed in execution plans are estimates. Becaues of this, they won't always add up to 100% or they may add up to WAY over 100%. It's nothing...
"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
October 21, 2009 at 6:29 am
Just so you know, this can frequently result in slower backups that cause some visible load on the server. I prefer to backup locally and then move the file across...
"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
October 21, 2009 at 6:26 am
There must be an error message reported in the maintenance job or in the logs. Find that error. If it doesn't tell you exactly what the problem is, post it...
"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
October 21, 2009 at 6:23 am
Funny, I'm going to come down just the opposite and say that I like option B for the same reasons that Jeff likes option A. I don't like having 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
October 21, 2009 at 6:21 am
No accountants here either... Nurses, Receptionists, Sales people... those I've seen try to be DBA's. Nurses weren't so bad, neither were the receptionists... keep the sales people away from the...
"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
October 20, 2009 at 7:36 pm
It sounds like a classic case of parameter sniffing. Try updating your statistics. If that doesn't resolve the issue, you may need to use an OPTIMIZE FOR hint on the...
"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
October 20, 2009 at 11:13 am
And I've seen the opposite. Until a recent bug fix, it was missing indexes that were blatant and obvious that resulted in major performance improvements. There's an MS Connect issue...
"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
October 20, 2009 at 8:50 am
I like the OUTPUT mechanism for batch inserts, but if you're doing single row inserts, you should be fine with SCOPE_IDENTITY() in almost all cases. If you read through the...
"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
October 20, 2009 at 8:06 am
Viewing 15 posts - 16,276 through 16,290 (of 22,219 total)