Viewing 15 posts - 19,651 through 19,665 (of 22,219 total)
Have you tried running the query against the base table?
Something is introducing a string in there.
"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
September 3, 2008 at 9:08 am
And RecId is, for sure, a bigint?
"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
September 3, 2008 at 8:39 am
Well, to get it to execute 10 times, just use this syntax:
EXEC myproc;
GO 10
As to how to gather the average of 10 executions... It depends on how you're capturing 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
September 3, 2008 at 8:37 am
Look up.
Sql Server Central...
"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
September 3, 2008 at 8:14 am
It's possible your external IP address has changed? You shouldn't be sending people your internal IP address because it won't help them.
BTW, this is a SQL Server 2008 Forum. 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
September 3, 2008 at 8:12 am
Excellent! Looking forward to 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
September 3, 2008 at 7:00 am
It only goes back as far as the last time the server was restarted, but you can track schema changes through the built in report "Schema Changes History." I ran...
"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
September 3, 2008 at 6:57 am
I'll pile on and suggest you have a Staging server that mirrors your Production environment (not necessarily in terms of memory & processing power, but certainly disk space) where 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
September 3, 2008 at 6:49 am
Holy cow, that's a ton of HUGE questions. Most of them can be answered, it depends.
To start with, it is possible to have too many relationships, but to determine if...
"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
September 3, 2008 at 6:46 am
Copy db or a Restore should work. The restore would have to include renaming the physical files. It's easier to use TSQL, but if you want to use the GUI,...
"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
September 3, 2008 at 6:40 am
I would have hoped for more of merge join than a loop...
"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
September 3, 2008 at 6:34 am
Disk operations working the way they do, more spindles is better than fewer. That's at least part of why SAN's (properly configured, propertly maintained, etc.) succeed so well. I would...
"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
September 3, 2008 at 6:31 am
Is it possible that you have cascade delete set up on the table? That might explain rows being deleted seemingly without action.
If you want to try to catch what's happening,...
"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
September 3, 2008 at 6:29 am
You're trying to select multiple rows into a single variable. That just won't work. What about running that same XML query directly against the data rather than trying to move...
"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
September 3, 2008 at 6:21 am
Now that I've taken the time to actually think about the answer to the question, yes, you'd need to recreate the script inside a monitor. Seems a bit odd 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
September 3, 2008 at 5:30 am
Viewing 15 posts - 19,651 through 19,665 (of 22,219 total)