Viewing 15 posts - 15,871 through 15,885 (of 22,226 total)
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
I didn't think to ask 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
February 3, 2010 at 12:24 pm
If it's doing no work at all, but using up all the memory on the system... I'd contact Microsoft. Open a PSS call or at least put it in Connect...
"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 3, 2010 at 9:33 am
Don't use a staging table, instead use SSIS to do the import and that way you can break down the records on the fly.
"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 3, 2010 at 9:31 am
GilaMonster (2/3/2010)
Um....
MySQL has pretty similar concepts too. I think I'll just start answering every question with a MySQL answer. After all, what's the difference really?
"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 3, 2010 at 7:42 am
tvantonder-992012 (2/3/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 3, 2010 at 7:08 am
No, I'm still not sure what's up.
One difference is I ran it on 2008. But there's little reason it should be 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
February 3, 2010 at 6:50 am
I think you need to further clarify what types of options you're looking for. Do you mean three different ways to rebuild an index? Do you mean three parameters you...
"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 2, 2010 at 7:24 am
Maybe I missed a step or something, but I just tested your script against a test database using SQL Agent and it ran without errors.
"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 2, 2010 at 7:00 am
Viewing 15 posts - 15,871 through 15,885 (of 22,226 total)