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...

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...

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...

Yeah, a serious lesson for all to be had in doing unto others...

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...

Jack Corbett (12/26/2008)

I would say can't. This is something...

If you add the case statement for Salesman1 in your group by statement you should be all set.

Can't or shouldn't? 🙁

Duplicate post - please refer to http://www.sqlservercentral.com/Forums/Topic625851-145-1.aspx

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"...

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...

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:

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...

My wife didn't get it but I was entertained. Thanks! 😉

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...