Viewing 15 posts - 11,206 through 11,220 (of 22,219 total)
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
Or just perform the MAX statement as a derived table (same thing as a CTE) and join to that. In this situation a CTE just changes the location of defining...
"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:21 am
Frankly, if I want to see code formatted my way, I just hit the CTL-K followed by CTL-Y.
"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 6:59 am
Except for the formatting, that code looks decent. If you want bad examples of TSQL from Microsoft you need to dig through the Books Online a little. There are several...
"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 6:31 am
Evil Kraig F (3/15/2012)
Grant Fritchey (3/15/2012)
GSquared (3/15/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 15, 2012 at 5:06 pm
GilaMonster (3/15/2012)
Grant Fritchey (3/15/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 15, 2012 at 4:26 pm
Viewing 15 posts - 11,206 through 11,220 (of 22,219 total)