Viewing 15 posts - 13,456 through 13,470 (of 22,227 total)
I would create a role to assign the users to and then assign that role to ddladmin, data_reader, data_writer, and security_admin for the database. That last role is probably 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 31, 2011 at 5:54 am
The hint when applied to a query will take precedence.
"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 28, 2011 at 1:10 pm
Wow... That's a rather large query. A couple of notes. You have NOLOCK all over the place. Yes, that prevents locking, but it can lead to bad data being returned...
"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 28, 2011 at 11:42 am
Abhijit More (1/28/2011)
nope I am finding out the ways we can beat the Operators.
You don't want to try to "beat the Operators." You want to try to work with 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 28, 2011 at 11:25 am
prakash_mc (1/28/2011)
Did you try new features (Schema / Data compate) available in Visual studio 2010 ?
Those have been available since the Visual Studio 2005 Team Edition. Decent tools. Really. Not...
"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 28, 2011 at 8:20 am
Glad I could help.
Yeah, 2008 you no longer have a choice on the JOIN syntax. Might as well jump.
Also, keep an eye out for opportunities to use UNION ALL instead...
"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 28, 2011 at 8:18 am
GilaMonster (1/28/2011)
sql_butterfly (1/28/2011)
As per my standards, the best execution plan should look like when you can see the 100% Index seek from a table (within a query).
I disagree. Only...
"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 28, 2011 at 5:50 am
This needs a ton of work to make it generic, parameterized, but if you guys want the raw form, this powershell script will automatically generate scripts for all databases on...
"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:02 pm
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
Viewing 15 posts - 13,456 through 13,470 (of 22,227 total)