Viewing 15 posts - 15,856 through 15,870 (of 22,219 total)
Greg Edwards-268690 (2/5/2010)
1. - Run backwards. Necessary speed would depend on whether the Turbo...
"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
February 5, 2010 at 9:51 am
David McKinney (2/5/2010)
"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
February 5, 2010 at 9:46 am
GilaMonster (2/5/2010)
namrata.dhanawade-1143388 (2/5/2010)
But that would mean to look at other things for my performance issue.Yup. Poorly written queries, inadequate indexing. Main causes of any perf problem.
Followed by data structures and...
"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
February 5, 2010 at 8:46 am
Roy nailed it. It generally has no impact until the query you're running requires SQL Server to reverse the order of the data. It can't do that for free.
"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
February 5, 2010 at 8:39 am
Creating an indexed view is not the same thing as creating an index. Actually, it's somewhat more expensive. If your data is highly volatile, as it gets constantly updated, 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
February 5, 2010 at 6:52 am
That's not a dirty read. You're not taking out an exclusive lock on the entire table when you start reading from it. Instead you're getting locks on each row and...
"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
February 5, 2010 at 6:46 am
Any query hint should be the absolute dead last option after every other possible tuning opportunity has been exhausted and even then, you should think three times before using them.
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
February 5, 2010 at 6:41 am
steve block (2/4/2010)
Sounds like a test question for a class or an interview question to me.Steve
Probably, but we're missing some context that lays down what the OP meant by 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
February 4, 2010 at 8:09 am
It could be compile time or it could be a question of data caching or it could be a combination of both.
Usually compile times are pretty benign unless the 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
February 4, 2010 at 6:56 am
If you don't have your clients running regular database backups... you should get on that right away, for all your clients.
"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
February 4, 2010 at 6:55 am
Mostly, believe it or not, these are technical questions, they're business questions. Ask your business how much data loss they're willing to put up with? That will begin to fill...
"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
February 4, 2010 at 6:51 am
Tuning Advisor, assuming it works correctly, and that's a huge assumption, will only suggest indexes for you. Indexes are not necessarily the problem. You need to gather performance metrics to...
"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
February 4, 2010 at 6:49 am
I'm not so sure it's that bad. I like to think of myself as reasonable successful in this field and competent at my job. I would make the claim to...
"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
February 4, 2010 at 6:27 am
You have a lot of stuff in the query that's going to lead to table scans. For example:
AND PAYCODENAME LIKE '%' + @PAYCODE + '%'
Will only allow for table scans....
"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
February 4, 2010 at 6:04 am
tvantonder-992012 (2/3/2010)
Msg 208, Level 16, State...
"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
February 4, 2010 at 5:58 am
Viewing 15 posts - 15,856 through 15,870 (of 22,219 total)