Viewing 15 posts - 12,001 through 12,015 (of 22,224 total)
Loner (8/22/2011)
I want to return all columnB.
Then I don't think columnb needs to be in the index at all. Since it's a clustered index, columnb is stored at the leaf....
"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
August 22, 2011 at 11:36 am
Indexed views are really only good if you have reasonably unvolatile data. If your data is being updated constantly then the indexed view is going to hurt more than 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
August 22, 2011 at 11:20 am
Roy Ernest (8/22/2011)
"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
August 22, 2011 at 10:28 am
Yuri55 (8/22/2011)
Just to share my experience with 4.5 TB database backup -use Red Gate Sql Backup 5, compression- 2, backup locally first then move to remote storage
And does...
"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
August 22, 2011 at 10:26 am
Assuming the plan is absolutely identical, then it sounds like resource contention or blocking. No way to know anything though based on the information supplied. These are just guesses.
"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
August 22, 2011 at 10:18 am
It really depends on the queries. Are they getting seeks on the index or not? Also, you said primary key, but is it the clustered index? How the cluster is...
"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
August 22, 2011 at 10:16 am
Roy Ernest (8/22/2011)
Let us say we have a table with 6 columns...
"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
August 22, 2011 at 10:09 am
Ninja's_RGR'us (8/22/2011)
The real problem is the join hint.I've never heard of <auto>-update stats causing problems. I'm not saying it's impossible, but on the very improbable side.
I have heard 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
August 22, 2011 at 9:53 am
Statistics are very small. By & large they won't get in the way and usually help. Unless you're seeing an issue, I wouldn't mess with it.
That said, sure, you 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
August 22, 2011 at 9:02 am
Yeah, I'd need to see the execution plan.
The fact that there is no WHERE clause is concerning. Queries that don't filter the data frequently lead to scans and there's little...
"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
August 22, 2011 at 8:21 am
Absolutely. Uninstall.
"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
August 22, 2011 at 8:20 am
One more for when you get back to the office. Another thing you might consider trying (and boy, oh boy, would I test this one to a fare thee 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
August 22, 2011 at 8:05 am
Ninja's_RGR'us (8/22/2011)
Grant Fritchey (8/22/2011)
"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
August 22, 2011 at 7:26 am
If you do a little searching, I posted the questions I used to ask on phone interviews, if you think that will help. But the in person interview... I guarantee,...
"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
August 22, 2011 at 6:15 am
ChrisM@Work (8/22/2011)
Anybody recruiting presently? We've been recruiting a DBA and a TSQL developer (with some role...
"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
August 22, 2011 at 6:13 am
Viewing 15 posts - 12,001 through 12,015 (of 22,224 total)