Viewing 15 posts - 991 through 1,005 (of 1,790 total)
That is referring to the performance counter SQLServer:General Statistics: User Connections
There must be a threshold configured in MOM that is set to look for that being over 500. If...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 31, 2008 at 4:03 am
From BOL:
USE AdventureWorks;
GO
SELECT DISTINCT 'EXEC sp_refreshview ''' + name + ''''
FROM sys.objects AS so
INNER JOIN sys.sql_expression_dependencies AS sed
ON so.object_id = sed.referencing_id
WHERE...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 1:57 pm
Jude, if you could provide feedback on which one is more efficient I would appreciate it. You should be able to pull some overall cost from the execution plan and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 9:04 am
Yeah, a serious lesson for all to be had in doing unto others...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 8:38 am
I don't think that not having it in the order by would cause you to have duplicate records. It is the grouping which is going to eliminate the dupes.
Glad...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 8:28 am
Jack Corbett (12/26/2008)
DavidB (12/26/2008)
Steve Jones - Editor (12/26/2008)
And they can't remove benefits from retirees. Those were agreed to long ago.Can't or shouldn't? 🙁
I would say can't. This is something...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 8:24 am
If you add the case statement for Salesman1 in your group by statement you should be all set.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 8:15 am
Steve Jones - Editor (12/26/2008)
And they can't remove benefits from retirees. Those were agreed to long ago.
Can't or shouldn't? 🙁
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 7:57 am
Duplicate post - please refer to http://www.sqlservercentral.com/Forums/Topic625851-145-1.aspx
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 7:46 am
If I understand what you are trying to do, you will need to use the charindex function to find the location of the "-" and the substring function to "trim"...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 7:44 am
This was something pretty common in 2000 but I haven't seen it with 2005. However, here are a couple of links to review.
http://decipherinfosys.wordpress.com/2008/06/26/performance-counters-are-missing/
http://support.microsoft.com/kb/300956
I would follow the steps in the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 6:48 am
Nice Lowell! I haven't worked with Oracle for a few years so, I couldn't pull all those details out like that but glad you were able to! :w00t:
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 5:03 am
Due to the variations between T-SQL and PL\SQL I would be really surprised if you were able to do a straight across migration. I would script out all the stored...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 26, 2008 at 4:57 am
My wife didn't get it but I was entertained. Thanks! 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 24, 2008 at 9:38 pm
Wow folks! I'm not a forum moderator (don't know if there are any besides Steve) but, not sure that this thread is profitable for anyone anymore.
Hopefully we can move...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 24, 2008 at 1:43 pm
Viewing 15 posts - 991 through 1,005 (of 1,790 total)