Viewing 15 posts - 2,656 through 2,670 (of 7,631 total)
Glad we could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 1:17 pm
I think thats just the process/session/request info, including the waiting lock summarized at the request level. But it doesn't have the detailed lock info, like entity_id.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 1:15 pm
Sorry, I can't think of a good way around it either.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 1:06 pm
Yes, but did you check for error messages in the Logtable? That was the point of my change.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 1:05 pm
You can't do anything to the 'sys' objects, unless you are 'sys' and you cannot make yourself 'sys'. The sys scripts contain some weird syntactic conventions to indicate things...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:59 pm
Like this:
SELECT
CRM_StatusCodes.TRANSACTION_ID
,CRM_StatusCodes.CREATED_AT
,CRM_StatusCodes.USER_STATUS, CRM_Serials.SERIAL
,CRM_PartsLabor.DESCRIPTION
,CRM_Orders.PRIORITY_DESCRIPTION
,CRM_Orders.PRIORITY
/*,CRM_StatusCodes.START_DATE*/
/*,CRM_StatusCodes.END_DATE*/
,CRM_CodeTexts.ABCDE_CODE_DESC
,CRM_Partners.DESCRIPTION AS [Function]
,CRM_Partners.ADDRESS
FROM
(
SELECT
CRM_StatusCodes.transaction_ID, count(*) TotalCount
FROM
CRM_StatusCodes
GROUP BY CRM_StatusCodes.transaction_ID
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:52 pm
That looks like a perfectly good CSV to me. What's the problem?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:46 pm
What PaulB said: we need to see what you saw in the Activity Monitor wrt to the locks.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:42 pm
Yes, this is correct, for most case if a search condition wraps a function around a column, then SQL cannot use an index on that column to resolve that search-condition...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:37 pm
The problem is that in you ELSE clauses you are RETURN-ing before you get to your COMMIT. You will need to write the ELSE's like this:
ELSE
Begin
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:18 pm
(puzzled) What do you mean by "a container"? I have never heard that term applied to something that costs money or in your context?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:07 pm
You're getting errors probably, but you are only logging the Command, not its output. Change the last few lines to this:
...
insert into logtable (query) select @query
insert into logtable (query)...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 12:01 pm
You know, it just occurred to me that the For Loop container should be able to handle this (duh).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 11:49 am
Karthik:
There is a course in most graduate & undergraduate math & CompSci programs called "Numerical Analysis", have you taken it yet? I ask because it is really...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 11:37 am
Not AFAIK. Installation is how you create an instance.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2009 at 11:30 am
Viewing 15 posts - 2,656 through 2,670 (of 7,631 total)