Viewing 15 posts - 13,456 through 13,470 (of 22,219 total)
As to why the costs might not accurately reflect performance, that's because query plan costs do not accurately reflect performance. They are estimates of cpu and io cost, completely dependent...
"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
January 27, 2011 at 3:03 pm
To my knowledge, that's a server level permission setting. We got around it by allowing developers the ability start a SQL Agent job that then started the trace.
"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
January 27, 2011 at 2:58 pm
There's always PowerShell and ADO. Pretty easy that way.
"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
January 27, 2011 at 2:57 pm
Wayne Coles (1/27/2011)
Thanks for replying,sorry for delay in my response, other things...u know
below is a sample of my code
select a1.id, a1.CoName,a1.Tel, a2.agent, a2.ondate,a2.result, a3.agent,a3.ondate,a3.nextaction
from details a1, history, a2, pending...
"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
January 27, 2011 at 2:56 pm
Check for contention, blocking, that would make prod run longer than dev. How about the physical machines themselves? I ran into situation once where I spent at least a day...
"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
January 27, 2011 at 2:48 pm
Pink123 (1/27/2011)
I am a begineer .
I tried to check the actual execution plan.
There is an index seek on Table A which having cost as 37%.There are other...
"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
January 27, 2011 at 2:21 pm
If your plan is to loop, you need to reassess the plan. What is it that you're trying to do?
"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
January 27, 2011 at 11:10 am
In addition to what the BitBucket asked for, please post the actual execution plans. Since we're not sitting in your chair, it's as close as we can get to seeing...
"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
January 27, 2011 at 11:09 am
I'm sorry, I realize I must be thick, but it's still not making sense to me. You're saying that maintaing the availability column in the table for a book, ccdvd...
"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
January 27, 2011 at 8:08 am
barryFS (1/27/2011)
Is it possible...
"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
January 27, 2011 at 8:01 am
Schuttberg (1/27/2011)
Table Triggers:None
(Check) Constraints:3 x "Default 0"; 1 "Column = 'NN' OR Column ='BST'"" (Simple, I think)
Foreign Key Constraints: None; ...
"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
January 27, 2011 at 7:57 am
Jeff Moden (1/26/2011)
Grant Fritchey (1/25/2011)
Maybe use the rule of three's like you suggested for mine? I thought it was a good idea.
I'll certainly Google for it but what is 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
January 26, 2011 at 7:36 pm
sqldba_icon (1/26/2011)
"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
January 26, 2011 at 5:00 pm
sqldba_icon (1/26/2011)
"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
January 26, 2011 at 4:58 pm
CirquedeSQLeil (1/26/2011)
Have you guys seen the news?
Close, very close. Nicely done.
"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
January 26, 2011 at 4:53 pm
Viewing 15 posts - 13,456 through 13,470 (of 22,219 total)