Viewing 15 posts - 1,171 through 1,185 (of 8,416 total)
Sergiy (1/13/2012)
January 13, 2012 at 7:01 am
Sergiy (1/13/2012)
SQL Kiwi (1/13/2012)
You claim that opening handlers IS execution. OK, let's pretend for a minute we've agreed on that.
Yes, code execution (as shown in the stack trace from...
January 13, 2012 at 7:00 am
You claim that opening handlers IS execution. OK, let's pretend for a minute we've agreed on that.
Yes, code execution (as shown in the stack trace from the debugger) is...
January 13, 2012 at 3:41 am
Sergiy (1/12/2012)
Here is the full execution tree for my batch: [...snip...]According to the plan, the 1st operation would be index seek on table @b-2.
Then comes table scan on table @A.
Are...
January 13, 2012 at 2:59 am
chandan_jha18 (1/13/2012)
January 13, 2012 at 2:33 am
chandan_jha18 (1/13/2012)
January 13, 2012 at 1:37 am
Evil Kraig F (1/12/2012)
nick-1043370 (1/12/2012)
January 12, 2012 at 11:15 pm
Sergiy (1/12/2012)
After reading articles from MVP and in BoL about "in-memory tables variables" I din't trust anyone's statements without verification.
So attach a debugger and verify it, like I did.
January 12, 2012 at 11:00 pm
Sergiy (1/12/2012)
There are so many holes and false assumptions in those articles...
No, they're just telling you things you don't want to listen to. If you don't believe the people...
January 12, 2012 at 10:58 pm
Sergiy (1/12/2012)
January 12, 2012 at 10:39 pm
Sergiy (1/12/2012)
That's exactly what I'm trying to prove:JOIN is executed (eliminating the extra row) BEFORE aggregation even starts to evaluate any upcoming values.
You are confusing the point in time at...
January 12, 2012 at 10:07 pm
Sergiy (1/12/2012)
Explanation:
Nothing is stopping an INDEX SEEK from being used and answer "A" is the correct answer.
Actually something does.
It's named "bookmark lookup".
There is no 'bookmark lookup' in this...
January 12, 2012 at 9:55 pm
L' Eomot Inversé (1/12/2012)
Jack Corbett (1/12/2012)
I don't see the only person who replied doing anything to get upset about or reply rudely or unprofessionally to.
I disagree with you on...
January 12, 2012 at 9:54 pm
Sergiy (1/12/2012)
If you run it like this you get an error:
Syntax error converting the varchar value 'a' to a column of...
January 12, 2012 at 9:47 pm
Sergiy,
I can assure you it works very much like Hugo has described; I'm afraid most of what you have asserted is incorrect. The explanation I gave for the answer...
January 12, 2012 at 9:35 pm
Viewing 15 posts - 1,171 through 1,185 (of 8,416 total)