Viewing 15 posts - 16,081 through 16,095 (of 22,232 total)
Roy Ernest (12/10/2009)
"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
December 10, 2009 at 6:41 am
Jack Corbett (12/10/2009)
"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
December 10, 2009 at 6:40 am
GilaMonster (12/10/2009)
Grant Fritchey (12/10/2009)
Jack Corbett (12/9/2009)
OPASS stands for Orlando PASS and, yes, that would be Florida with Disney and all that. It was 80's today and we have 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
December 10, 2009 at 6:39 am
sqllearner-339367 (12/10/2009)
I have tried executing stored procedure and dynamic query under the same ansi setting. Execution time is 1min:05 seconds for stored procedure and 30 seconds for dynamic query.
Im...
"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
December 10, 2009 at 6:37 am
Jack Corbett (12/9/2009)
OPASS stands for Orlando PASS and, yes, that would be Florida with Disney and all that. It was 80's today and we have the AC on now,...
"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
December 10, 2009 at 5:23 am
Jeff Moden (12/9/2009)
Grant Fritchey (12/9/2009)
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
BWAA-HAAA!!! Whenever I get a "make...
"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
December 10, 2009 at 5:21 am
Lynn Pettis (12/9/2009)
How the .... did this person get a job in IT?????The force in this one is not only weak, I think it is nonexistant.
Same guy that wanted 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
December 9, 2009 at 11:42 am
I'd say that moving a gb of data in a single query in 3 minutes is decent, if not great, performance. What is the user doing with 2 million rows...
"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
December 9, 2009 at 11:23 am
I'd want to see execution plans to determine that you're reallly looking at two different sets of behavior. Does the connection calling the store procedure have the same ANSI settings...
"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
December 9, 2009 at 11:17 am
I can't think of a single way of doing this either. Most of the DMV's that I can think of that might relate to this only store aggregate information, so...
"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
December 9, 2009 at 11:15 am
GilaMonster (12/9/2009)
Krasavita (12/9/2009)
Yes,Iwas told our LockPage setting in memory needs to be set to true, but wehere is it? Thank you
I'm assuming that you didn't bother to read the two...
"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
December 9, 2009 at 10:33 am
I'm honestly trying to help the guy, but man... could you make it more difficult?
"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
December 9, 2009 at 8:46 am
The first thing that comes to mind from what you just posted is the ability to pin a table. This means that the table is pinned into memory to elminate...
"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
December 9, 2009 at 8:45 am
I always forget this one. How do you flip the "run faster" switch to the on position in SQL Server?
"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
December 9, 2009 at 8:26 am
Krasavita (12/9/2009)
I was told there is a switch on sql server that needs to be turn on to increase perfomance on sql server
Again, a lot more specific information needs 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
December 9, 2009 at 8:24 am
Viewing 15 posts - 16,081 through 16,095 (of 22,232 total)