Viewing 15 posts - 18,106 through 18,120 (of 22,219 total)
GilaMonster (3/4/2009)
Derek Dongray (3/4/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
March 4, 2009 at 1:43 pm
Right. Now there really is something to report. He lifted that list. Go here and read through this:
http://www.sql-server-performance.com/tips/t_sql_where_p1.aspx
I found the tip that upset me on page 5. I'm not sure...
"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 4, 2009 at 1:38 pm
Gail, Jeff & Steve are the three MVP's I know that haunt this thread. After I posted to the blog I had a different MVP send me a direct message...
"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 4, 2009 at 1:29 pm
Posted on the blog and didn't mention names or start a fight:
http://scarydba.wordpress.com/2009/03/04/bad-performance-tip/%5B/url%5D
"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 4, 2009 at 1:13 pm
Someone else mentioned checking the Agent error log specifically, not just the SQL Server error log. Other than that, I'll let the reinforcements take over.
"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 4, 2009 at 12:35 pm
Oh man, I was counting on you guys. I get in over my head.
"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 4, 2009 at 12:12 pm
Good old fashioned sp_who2 could help here too.
You don't want to run Profiler on your production system. What you want to do is set up a server side trace. It's...
"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 4, 2009 at 12:10 pm
Ninja's_RGR'us (3/4/2009)
Looks to me like we need about another 2000 MVP nominations just...
"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 4, 2009 at 12:04 pm
GilaMonster (3/4/2009)
Grant Fritchey (3/4/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
March 4, 2009 at 12:00 pm
I've got a poster that I really don't know how to help.
http://www.sqlservercentral.com/Forums/FindPost668188.aspx
"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 4, 2009 at 11:59 am
I'm not aware of one. Hang on a sec. Let me get help.
"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 4, 2009 at 11:53 am
Bob Hovious (3/4/2009)
try to order the list of values so that the most frequently found values are placed first
Grant, I've read somewhere a while back that 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 4, 2009 at 11:24 am
GilaMonster (3/4/2009)
Grant Fritchey (3/4/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
March 4, 2009 at 11:21 am
I don't know. I'm not sure you can modify it. If I look at the SQL Server Configuration Manager, I can see the settings within the Agent, but it's 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 4, 2009 at 11:09 am
Another one. This was interesting. If you spot something wrong with my tests, let me know. This is going up as a blog post, with names changed (and grammar fixed...
"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 4, 2009 at 11:00 am
Viewing 15 posts - 18,106 through 18,120 (of 22,219 total)