Viewing 15 posts - 15,871 through 15,885 (of 22,219 total)
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
A couple of things, have you looked at the execution plan? If you have and you don't understand what's happening there, save it as a .sqlplan file and post 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 2, 2010 at 6:00 am
A couple of ways that work pretty well. First, and this will work in 2000/05/08, is to use a sub-select with the TOP and ORDER BY operation like this:
SELECT ...
FROM...
"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 5:58 am
I've gotten farther and farther away from enforcing naming standards. Too much time working with CRM, Sharepoint and ORM tools. Basically, I'd make the table names clear. Instead of tm_TableName...
"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 5:44 am
It's best to try to avoid the whole arc relationship if you can. This is when you have a thing, Comment, that can be related to multiple other things, but...
"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 5:37 am
Lynn Pettis (2/1/2010)
Grant Fritchey (2/1/2010)
SpamDid you report it?
Yepper.
"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 1, 2010 at 7:28 am
Spam
"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 1, 2010 at 7:15 am
Lynn Pettis (1/30/2010)
bitbucket-25253 (1/30/2010)
is said that you are never more than 6 persons removed from every other person on this earth
Always thought that was a fallacy...
"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 1, 2010 at 5:32 am
Viewing 15 posts - 15,871 through 15,885 (of 22,219 total)