Viewing 15 posts - 18,106 through 18,120 (of 22,226 total)
Steve Jones - Editor (3/5/2009)
I think things work well as is. Relatively few people would likely use any...
"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 5, 2009 at 7:17 pm
This post has a bit irony attached I think:
http://mangalpardeshi.blogspot.com/2009/03/how-to-disable-right-click-on-your-blog.html
"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 4:32 pm
Yeah basically. There are other tools you could use to help out. When you're really trying to figure out what's causing the server to slow down (or stop), this is...
"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 4:28 pm
Also, I always forget about this, but you can use the object explorer details window. Click on, say tables in the object explorer window and you'll see the list of...
"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 3:11 pm
kellyrmartin (3/4/2009)
ANother question. Can someone explain the difference between a Lock and a Block? Are you guys suggesting 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
March 4, 2009 at 3:08 pm
GilaMonster (3/4/2009)
Grant Fritchey (3/4/2009)
It looks like it was all pulled from Brad Magehee. I reported it to him via Twitter. No response yet.
I doubt Brad wrote all of those. He...
"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 2:57 pm
Jack Corbett (3/4/2009)
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 1:44 pm
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
Viewing 15 posts - 18,106 through 18,120 (of 22,226 total)