Viewing 15 posts - 18,091 through 18,105 (of 22,202 total)
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...
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
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.
March 4, 2009 at 12:35 pm
Oh man, I was counting on you guys. I get in over my head.
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...
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...
March 4, 2009 at 12:04 pm
GilaMonster (3/4/2009)
Grant Fritchey (3/4/2009)
March 4, 2009 at 12:00 pm
I've got a poster that I really don't know how to help.
March 4, 2009 at 11:59 am
I'm not aware of one. Hang on a sec. Let me get help.
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...
March 4, 2009 at 11:24 am
GilaMonster (3/4/2009)
Grant Fritchey (3/4/2009)
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...
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...
March 4, 2009 at 11:00 am
Bob Hovious (3/4/2009)
21. In case using GROUP BY without an aggregate function try using DISTINCT instead
To my knowledge, I have never used a GROUP BY without an aggregate...
March 4, 2009 at 10:39 am
Check the service for Agent to be sure it's running under an account that has appropriate priveleges on your server.
March 4, 2009 at 9:39 am
Viewing 15 posts - 18,091 through 18,105 (of 22,202 total)