Viewing 15 posts - 12,511 through 12,525 (of 22,227 total)
But if you're in 2005 or above you can right click on the plan and select "Save As"
"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
May 23, 2011 at 11:01 am
Danzz (5/23/2011)
@ Grant FritcheyThanks for the reply.
For sure the SQL Queries are slow. How do I start over and troubleshoot.
Tuning queries is a huge topic. If you start with...
"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
May 23, 2011 at 10:05 am
Ninja's_RGR'us (5/23/2011)
Indianrock (5/23/2011)
Thanks Grant. Time to read your book on execution plans. It's sounding like no magic bullet here.
there's no magic bullet for any global tuning process... always takes...
"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
May 23, 2011 at 7:19 am
There have been entire books written on the topic of Execution Plan Operators.
For one example, look in my signature line.
"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
May 23, 2011 at 5:52 am
You're seeing the difference between dynamic tsql and prepared statements. You'd see the same thing if you put the code into a stored procedure instead of building the TSQL statement.
Run...
"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
May 23, 2011 at 4:44 am
It's fairly rare to need to do a FULL SCAN on all your stats. It's probably only a few tables that really need that. Unfortunately those are usually the larger...
"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
May 23, 2011 at 4:21 am
If you know for sure which queries are slow, take a look at the execution plans and see what they're doing. Tune the queries. If you're not sure which queries...
"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
May 23, 2011 at 4:18 am
Best bet, take a look at the execution plan. You'll see what is being done by SQL Server to retrieve the data as defined by the CTE and the query...
"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
May 23, 2011 at 4:09 am
GilaMonster (5/23/2011)
Now this is funny...http://blog.jitbit.com/2011/05/what-if-drivers-were-hired-like.html
Way too accurate.
"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
May 23, 2011 at 3:59 am
jasonshaw (5/23/2011)
GUID is a new concept to me and I am not sure that I works in this case as it is not good for indexing...
"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
May 23, 2011 at 3:54 am
Q: Ever heard of nHibernate?
A: Yes
Q: Next candidate!
Those are decent questions, but they lean a bit heavily towards database development and little away from straight-up development. You might want...
"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
May 20, 2011 at 11:57 am
Thanks. Glad to hear that stuff is useful. That's the goal.
"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
May 20, 2011 at 11:45 am
I've seen designs like this in the past and they lead to serious bottlenecks. I'm with Gus. If you have to do this a GUID is your best bet.
But, be...
"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
May 20, 2011 at 8:17 am
odanwada (5/19/2011)
I think my manager wants 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
May 20, 2011 at 6:45 am
Must be that the procedure was created with a different schema as owner.
"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
May 20, 2011 at 6:42 am
Viewing 15 posts - 12,511 through 12,525 (of 22,227 total)