Viewing 15 posts - 11,206 through 11,220 (of 22,224 total)
No way to know that for sure based on what you provided. It could be almost anything. Look to see if you have errors before this one. Also, if 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
April 1, 2012 at 7:42 am
If you're just moving data from a single server to a second server then you need to tune the procedures and processes in place. If you're trying to copy 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
April 1, 2012 at 6:47 am
Wrap the whole thing in a transaction first. Then, use the OUTPUT clause to output to a temp table or a table variable (a table variable would probably work well...
"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 1, 2012 at 6:45 am
CELKO (3/31/2012)
This is impossible because the key columns cannot be NULLs.
Exactly what I was thinking. Even if you could, and assuming you have a key constraint in place, you can't,...
"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 1, 2012 at 6:43 am
Also, check for blocked processes and collect the wait stats before & during running the procedure to see what's causing stuff to slow down.
"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 1, 2012 at 6:39 am
Another vote for reading Gail's excellent articles.
You can take a look at sys.dm_exec_requests to see if you're getting blocking on any of the processes. I'd probably start there on a...
"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 1, 2012 at 6:35 am
I have seen backups cause problems with a server, but usually only if that server is already operating right at the edge, with extremely have I/O & Memory operations. In...
"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 1, 2012 at 6:31 am
If the transaction completes during the database backup process, it will be included in the backup. Data that is changed during the backup process is logged at the end of...
"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 1, 2012 at 6:27 am
Same process as any rollout or upgrade, you have a solid set of tested backups. The key word in that sentence is tested. Other than that, since the old days...
"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
March 21, 2012 at 5:11 am
I don't think you can without taking the log shipping offline and then rebuilding 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
March 20, 2012 at 6:13 am
Service packs we would routinely install on Dev and QA systems as they came out. We'd then be able to get a decent evaluation if they were problematic without having...
"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
March 20, 2012 at 6:08 am
How many Pay_Type_ID are left? Because it might make more sense to put in the remaining values as = with a few OR clauses rather than that really long long...
"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
March 20, 2012 at 6:06 am
That's absolutely a new one to me. I wouldn't think that defragmenting the indexes would change the size of the backup.
Did you maybe update SQL Backup to a new version?...
"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
March 20, 2012 at 6:02 am
It's only going to use 8 at a time. The OS may point it to different ones at different times, but SQL Server won't hit all 16.
"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
March 19, 2012 at 9:27 am
Koen Verbeeck (3/19/2012)
Grant Fritchey (3/19/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
March 19, 2012 at 7:55 am
Viewing 15 posts - 11,206 through 11,220 (of 22,224 total)