Viewing 15 posts - 15,181 through 15,195 (of 22,219 total)
I agree with Dave, specifics on your system are hard to say without a lot more detail. However, I would be very careful about indexes 2 & 3 in that...
"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
May 4, 2010 at 6:15 am
Try RESTORE FILELISTONLY. I think that'll get you what you want.
"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
May 4, 2010 at 6:12 am
Whoa! A covering index is not a index that includes every column in the table. That's wrong.
A covering index is an index that provides all the columns needed by 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
May 4, 2010 at 6:09 am
Why is archiving taking so long? Are you trying to move everything or is it that the queries themselves are taking so long? If the queries are running slow because...
"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
May 4, 2010 at 6:01 am
Just remember that you'll need to sweat contention for resources, i/o, cpu, memory, tempdb, all are part & parcel of creating indexes, so testing in a completely isolated environment 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
May 4, 2010 at 5:58 am
I don't see any reason why the commit would not fire. Maybe using TRY/CATCH instead of the old style error handling will allow you to control the flow better. 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
May 4, 2010 at 5:23 am
Agreed. That's not really an 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
May 3, 2010 at 7:08 pm
Check the login that the scheduling service is running under. Check the owner of the job that is being run and check the security settings on the script itself. It's...
"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
May 3, 2010 at 6:38 pm
Steve Jones - Editor (5/3/2010)
Your ed is coming soon. Haven't had time to go over the podcast, but I'll get it sorted and out next week.
I'm actually not worried about...
"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
May 3, 2010 at 12:50 pm
The basics are easy:
Run the Upgrade Advisor
Fix any issues
Migrate the logins
Backup the databases on the old server
Restore the databases on the new server
Run DBCC checks (a little paranoia goes 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
May 3, 2010 at 11:57 am
Steve Jones - Editor (5/3/2010)
It does seem to be tough pulling information out of people today. The "ideal SQL Server" thread has me slightly frustrated.
Based on that thread, please run...
"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
May 3, 2010 at 11:55 am
Gianluca Sartori (5/3/2010)
At least, I'm not aware of any way this could happen, but I could be flat wrong.
Can...
"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
May 3, 2010 at 9:01 am
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles.
Why? SQL won't recompile when a different...
"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
May 3, 2010 at 8:50 am
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles.
Why? SQL won't recompile when a different branch is taken....
"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
May 3, 2010 at 8:36 am
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles. If you need to set up this kind of IF clause, then...
"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
May 3, 2010 at 8:24 am
Viewing 15 posts - 15,181 through 15,195 (of 22,219 total)