Viewing 15 posts - 12,511 through 12,525 (of 22,224 total)
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
Take a look at the RML Utilities from Microsoft. You can set up a work load and automate the replay of that workload or use a trace file and automate...
"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:39 am
Another option is to skip the trace entirely and pull the data from cache using dynamic management objects. Selecting from sys.dm_exec_query_stats will show you aggregate information about a query 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
May 20, 2011 at 6:37 am
You can set this up pretty easily by using SQL Agent. You can query for the processes that are in place using sys.dm_exec_requests. With that you can get the session...
"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:33 am
Viewing 15 posts - 12,511 through 12,525 (of 22,224 total)