Viewing 15 posts - 16,501 through 16,515 (of 22,226 total)
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
Jeff Moden (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 17, 2009 at 8:12 pm
Bob Hovious-584421 (9/17/2009)
Chicks dig scars.Did anyone ever say where Gail disappeared to?
She hasn't been here recently, but she's still about. She posted a comment over on my blog recently (fixing...
"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 17, 2009 at 12:41 pm
lmu92 (9/17/2009)
Grant Fritchey (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 17, 2009 at 12:07 pm
Seth Lynch (9/17/2009)
sanjeev_krs2004 (9/17/2009)
Its just a simple maintenance plan where I am rebuilding indexes, reorganizing indexes, shrink database...etc. All the usual stuff. Secondly, I am not sure but...
"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 17, 2009 at 11:59 am
lmu92 (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 17, 2009 at 11:57 am
Silverfox (9/17/2009)
Grant Fritchey (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 17, 2009 at 11:47 am
Yeah, I guess I didn't say it my post, it's fine to index a VARCHAR column, but you need to test, test, test. The same goes for any index 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
September 17, 2009 at 11:42 am
The view all by itself isn't the issue. It really is about caching the plan and caching the data. From the sounds of it, your data cache is well 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 17, 2009 at 11:39 am
Viewing 15 posts - 16,501 through 16,515 (of 22,226 total)