SQL Kiwi (1/15/2012)

---

So the fuel counter executes first, cool. [/qoute]

Which means - Fuel counting executes before fuel is pumped.

Did you try it on real life people?

🙂

It's not a...

How happy are those people about this one:

Cursor loop executes before the first row of the cursor...

So?

Both fuel counter...

Another loose point I found in this article, which possibly leads to a wrong understanding:

http://bradsruminations.blogspot.com/2010/11/second-in-life-of-query-operator.html

Here is my test query:

DECLARE @A TABLE (a varchar(20) NOT NULL)

DECLARE @b-2 TABLE (b varchar(20) NOT...

Sounds right.

I need to find out...

Staying within the terms of executable codes:

- Cursor loop executes before its first row is fetched.

- Main...

"Executes" has more in it then "starts execution".

Person D is still in process of execution when all others are done.

So,...

Really?

What is off in this analogy?

Now you would argue that...

SQL Kiwi (1/13/2012)

---

Sergiy (1/13/2012)

---

You say - pouring is coming 1st, because before counter can start counting you must open the cap and put the nozzle into the hole. All...

SQL Kiwi (1/13/2012)

---

Yes, code execution (as shown in the stack trace from the...

I'm not assuming anything.

I state what I see from the Profiler...

SQL Kiwi (1/12/2012)

---

If you are not prepared to accept the hard evidence presented here, the arguments presented by three current MVPs,

articles from people like Craig Freedman (who wrote parts of...

There are so many holes and false assumptions in those articles...

Some of them...

Here is the full execution tree for my batch:

StmtText ...

SQL Kiwi (1/12/2012)

---

With the JOIN in place, the row is eliminated by the join (no matching row in table B) before the expression is evaluated by the aggregate, so no...