Showing posts with label execution. Show all posts
Showing posts with label execution. Show all posts

Tuesday, March 20, 2012

Bug: Query Analyser (german): Cost, percentage, .. in graphical execution plan are wrong

Hi to all,
there is an anoying bug in the Query Analyser (german) version 8.00.760:
In the graphical execution plan costs, percentage, ... are wrong!
If I use set showplan_all on, I will get the right values.
I guess it might be the german decimal character!
If I change the country settings to english(usa) everything ist ok.
Couldn't find this on the msdn side.
Is there any bugfix.
markusi think this applies to all europeans versions that
use "," in place of the english "."
it is possible the numerical values are generated by sql
server, and the graphical display by QA, which may be
handling the european convention
-sorry don't know of fix, i mostly work with US settings
>--Original Message--
>Hi to all,
>there is an anoying bug in the Query Analyser (german)
version 8.00.760:
>In the graphical execution plan costs, percentage, ...
are wrong!
>If I use set showplan_all on, I will get the right values.
>I guess it might be the german decimal character!
>If I change the country settings to english(usa)
everything ist ok.
>Couldn't find this on the msdn side.
>Is there any bugfix.
>markus
>
>.
>|||I reported this as a bug back in April but I don't believe there is a fix
available.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Markus Wimplinger" <markus.wimplinger@.cds.co.at> wrote in message
news:%23jZ5F6JmDHA.2488@.TK2MSFTNGP12.phx.gbl...
Hi to all,
there is an anoying bug in the Query Analyser (german) version 8.00.760:
In the graphical execution plan costs, percentage, ... are wrong!
If I use set showplan_all on, I will get the right values.
I guess it might be the german decimal character!
If I change the country settings to english(usa) everything ist ok.
Couldn't find this on the msdn side.
Is there any bugfix.
markus

Thursday, February 16, 2012

Breakpoint in child-package triggered on first execution only.

I have a child package which is executed several times within the same SSIS ETL. I have placed a break point on one of the child package's tasks, set to trigger on a PreExecute() event. The first time the child package is invoked, the breakpoint is triggered. However, on each successive invocation the breakpoint is ignored. Does anybody know if this behaviour is normal? Thanks in advance!

This is a known issue and we are aware of the bug. Thanks