Viewing 15 posts - 15,631 through 15,645 (of 22,227 total)
Lynn Pettis (3/29/2010)
I can understand you concerns. We would be interested in hearing your suggestons to address those concerns. To be honest, I think we are trying to...
"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
March 29, 2010 at 7:52 am
If you are sure that you're properly refreshing the cache, then you may be hitting a bug. All the tests I've run show it working just fine, so I'm 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
March 29, 2010 at 6:54 am
I've been primarily lurking, but I've decided to put in two points.
First, I'm not crazy about a lot of the suggested directions for a middle-level certification that have been put...
"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
March 29, 2010 at 6:39 am
Jeff Moden (3/29/2010)
Heh... thanks, guys. Can I relax now or do I need more for "the mug"? 😛
The mug? Sorry, 20k was for the badge. To get a mug...
"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
March 29, 2010 at 6:19 am
Only memorable ones I have are WAY back in the early nineties at Merrill Lynch one of our Unix admins was a star gazer. We had Betelguese & Rigel that...
"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
March 26, 2010 at 1:07 pm
Lynn Pettis (3/26/2010)
Grant Fritchey (3/26/2010)
... Wrong or not, you're a better man than I am Gunga Lynn....
Love the parody.
Perhaps we need more discussions like this, between close friends 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
March 26, 2010 at 11:12 am
Jack Corbett (3/26/2010)
Grant Fritchey (3/26/2010)
Lynn Pettis (3/26/2010)
CirquedeSQLeil (3/26/2010)
Lynn, you opened up a big old can.
Neck and head hurt, don't care. 😛
Sometimes the truth hurts. I really need to start...
"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
March 26, 2010 at 9:34 am
Lynn Pettis (3/26/2010)
CirquedeSQLeil (3/26/2010)
Lynn, you opened up a big old can.
Neck and head hurt, don't care. 😛
Sometimes the truth hurts. I really need to start posting on my Geek...
"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
March 26, 2010 at 9:10 am
TheSQLGuru (3/26/2010)
ss-457805 (3/25/2010)
Grant, You are a genius. The query has come down to 6 secs with your recommendations.Thank you.
Oy vey - there goes Grant's ego!! 😀
No, no. My ego...
"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
March 26, 2010 at 8:15 am
The problem is you're explaining the table and it's size and that you have a problem, but you're not describing what the problem is. Are you having trouble on inserts?...
"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
March 26, 2010 at 8:10 am
Those things you're looking at are considered the best practices.
"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
March 26, 2010 at 7:09 am
Bhuvnesh (3/26/2010)
Grant Fritchey (3/26/2010)
You do know, as that table scales, this query will become slower and slower.
Frankly tell you this would be a intermediate/ working table ( prefebly a...
"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
March 26, 2010 at 7:00 am
I don't think any index is going to help the query, but, I'd strongly suggest you identify the primary key on the table and make that a clustered index. This...
"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
March 26, 2010 at 6:50 am
I'm assuming you're using a lot of automatic settings, so your databases are probably on auto-grow. Nothing wrong with that, but now you need to monitor disk free space very...
"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
March 26, 2010 at 6:48 am
I think it looks OK. Test it on a different machine first to verify you get what you need.
"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
March 25, 2010 at 12:39 pm
Viewing 15 posts - 15,631 through 15,645 (of 22,227 total)