Viewing 15 posts - 16,486 through 16,500 (of 22,219 total)
I wouldn't be surprised if you can tune it further. Nice to hear that it's working better.
"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
September 19, 2009 at 5:45 am
Yes, but what is occuring inside the function? Is it a single statement function with a query against a single table just with parameters or are multiple tables involved in...
"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
September 19, 2009 at 5:44 am
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/2009)
"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
September 19, 2009 at 5:30 am
Roy Ernest (9/18/2009)
I know I am not the best article writer.. 🙂 But I think I will give it a try if I ever am able to make some time....
"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
September 19, 2009 at 5:27 am
I'm a little confused on the idea of a function vs. a join. If you have two sets of data that you want to put together, you have 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
September 18, 2009 at 1:16 pm
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/2009)
"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
September 18, 2009 at 1:06 pm
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/2009)
"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
September 18, 2009 at 12:29 pm
Oh, and, in cases like this, all the execution plans are going to be relevant.
"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
September 18, 2009 at 12:25 pm
Table variables don't have statistics. That's probably the issue based on how you're using them in JOIN's. Try doing the same thing with temporary (#temp) tables and see if 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
September 18, 2009 at 12:24 pm
You may have an index, but is it getting used? Have you looked at the actual execution plan? Can you post 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
September 18, 2009 at 12:15 pm
GSquared (9/18/2009)
Paul White (9/18/2009)
Whenever I consider writing for SSC, two things put me off:1. The submission process itself; and
2. The daft comments
Paul
I must be doing something wrong. ...
"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
September 18, 2009 at 8:00 am
Assuming you're talking about a situation where you're running SELECT... SELECT... SELECT... SELECT... and you're not putting all kinds of IF logic in there, then yes, running all four at...
"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
September 18, 2009 at 7:53 am
Yep, sorry, parsed this sentence multiple times and I'm still confused.
Could you explain in a bit more detail what it is 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
September 18, 2009 at 7:49 am
Jim-1146873 (9/17/2009)
Can anyone help me out how to take a backup of a database between a specified duration.
For ex, i want to take back up between August 1st 2009 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
September 18, 2009 at 7:43 am
Lynn Pettis (9/17/2009)
"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
September 18, 2009 at 6:40 am
Viewing 15 posts - 16,486 through 16,500 (of 22,219 total)