Viewing 15 posts - 11,071 through 11,085 (of 22,219 total)
I would be very careful about using reorganize as a mechanism for performance enhancements. I've seen tests run by Brad McGehee and it's only of marginal use within a very...
"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
April 18, 2012 at 7:46 am
Informational, bad ones, and really bad ones.
Can you narrow down what it is that you're looking for? There are all sorts of possible errors, so knowing more about what 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
April 18, 2012 at 7:39 am
Your best bet is write a script that will do all the databases. You can use sp_foreachdb, which is just a cursor, to run a command on all databases.
Alternatively, 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
April 18, 2012 at 6:27 am
I'd get a look at the execution plan. If the query is against millions of rows without an index, likely it's creating a hash table in order to do 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
April 18, 2012 at 6:24 am
WayneS (4/16/2012)
Brandie Tarvin (4/16/2012)
1) What does sp_kleenex do 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
April 17, 2012 at 4:34 am
Thanks to both. Glad to hear it's useful.
"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
April 17, 2012 at 4:29 am
Jeff Moden (4/13/2012)
capn.hector (4/13/2012)
"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
April 14, 2012 at 5:32 am
zojan (4/13/2012)
Sean Lange (4/13/2012)
jzoran (4/13/2012)
"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
April 14, 2012 at 5:27 am
Evil Kraig F (4/12/2012)
Koen Verbeeck (4/12/2012)
GilaMonster (4/12/2012)
"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
April 13, 2012 at 10:19 am
pallavi.unde (4/12/2012)
Can you please tell me what query execution plan does actually to help us in performance tuning? How it could i use?
Execution plans show you the decisions made...
"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
April 13, 2012 at 10:18 am
If you're getting bad plans, it can still be because of the stats.
If the plans you're getting are working in an inconsistent manner, then recompile might not be the best...
"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
April 13, 2012 at 10:17 am
DBA_Dom (4/12/2012)
Grant Fritchey (4/12/2012)
"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
April 12, 2012 at 1:51 pm
Lynn Pettis (4/12/2012)
What would happen here on SSC if the TOP 25 posters did nothing but lurk for 24 hours?
Not much. There'd just be a few more unchallenged suggestions 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
April 12, 2012 at 11:40 am
pallavi.unde (4/12/2012)
Suppose i have one big query which is taking 20 minutes for execution, how could i...
"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
April 12, 2012 at 9:32 am
Oh lord, I think someone either has a homework panic (as seems to be standard around here) or is WAY over their heads at their job. They want me 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
April 12, 2012 at 5:18 am
Viewing 15 posts - 11,071 through 11,085 (of 22,219 total)