Viewing 15 posts - 18,121 through 18,135 (of 22,219 total)
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...
"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 10:39 am
Check the service for Agent to be sure it's running under an account that has appropriate priveleges on your server.
"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 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...
"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 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...
"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 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...
"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 9:17 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...
"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 9:11 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 9:04 am
GilaMonster (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 7:40 am
Chris Morris (3/4/2009)
Welcome! ...you're not going to ask the business reason then? 😉
Question a free beer? Surely that way lies madness.
"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 7:37 am
Can I just add that I think this is the first time I've seen an active blanket party on this site. This poor guy sure did pick a fight, if...
"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 6:56 am
One of the toughest things is learning the new technology. It's hard to pick up on all the new functionality available. I'm still floundering with MERGE in TSQL and I'm...
"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 6:45 am
I think, for the time being, you're stuck. If you're using the GDR version of VSTS:DB, it does allow for third party database connections, but I'm not aware of 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 4, 2009 at 6:43 am
Like Lynn says, you can't do it. SQL Server manages it's own sessions and threads and you can't direct them. If two processors are available and nothing but these two...
"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 6:38 am
Chris Morris (3/4/2009)
Wipe yer eyes mate, here's a Fuller's ESB, probably the best beer in the world.
Ooohhh... Beer! And an ESB. I'm happy again. Cheers!
"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 6:24 am
jcrawf02 (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 6:11 am
Viewing 15 posts - 18,121 through 18,135 (of 22,219 total)