Viewing 15 posts - 12,001 through 12,015 (of 22,219 total)
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
A friend of mine has been IT for non-profits for a while. I'll see if I can't get him to swing by & comment.
"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 4:46 am
Nope. And you'd best hope your potential future employer doesn't do searches out there to try to find out where and how you post. They'll see what could easily be...
"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 4:44 am
There's no way to no for sure if any technology will survive for long. However, look at like this. None of the new technologies looks poised to take over relational...
"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 4:39 am
And that's why you only store 4000 some odd characters instead of 8000 some odd without resorting to using MAX. That's for nchar & nvarchar.
"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 4:34 am
No, an hour seems very excessive for that query.
"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 4:03 am
Viewing 15 posts - 12,001 through 12,015 (of 22,219 total)