Viewing 15 posts - 18,106 through 18,120 (of 22,214 total)
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
That's really up to you & your business. There are some improvements between 2005 and 2008 that could be a huge boon for you (we're going to start working with...
March 4, 2009 at 9:38 am
Derek Dongray (3/4/2009)
I've looked at some of his recent responses on MSDN and a lot of them seem to be...
March 4, 2009 at 9:26 am
Lynn Pettis (3/4/2009)
Bob Hovious (3/4/2009)
He started his career as an ERP Technical Consultant in 2007.
Call me old-school, but I cannot understand someone STARTING their career as a consultant.
QUESTION!! How...
March 4, 2009 at 9:17 am
Viewing 15 posts - 18,106 through 18,120 (of 22,214 total)