Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 6,036 total)

  • RE: Query Plan Execution Order

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

    January 15, 2012 at 11:46 pm

    #1433901

  • RE: Query Plan Execution Order

    SQL Kiwi (1/15/2012)

    The vast majority of people are happy with the phrasing used.

    How happy are those people about this one:

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

    January 15, 2012 at 10:30 pm

    #1433889

  • RE: Query Plan Execution Order

    SQL Kiwi (1/15/2012)

    Sergiy (1/15/2012)

    Really? What is off in this analogy?

    Really, yes. Does the fuel counter reset before any fuel starts being delivered? Of course.

    So?

    Both fuel counter...

    January 15, 2012 at 10:23 pm

    #1433887

  • RE: Query Plan Execution Order

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

    January 15, 2012 at 5:06 pm

    #1433869

  • RE: Query Tuning

    SQL Kiwi (1/12/2012)

    There is no 'bookmark lookup' in this case as Jeff's explanation of point H reveals: the non-clustered index is covering for the query.

    Sounds right.

    I need to find out...

    January 15, 2012 at 4:19 pm

    #1433868

  • RE: Query Plan Execution Order

    SQL Kiwi (1/13/2012)

    I say that an executable plan is exactly that: executable code.

    Staying within the terms of executable codes:

    - Cursor loop executes before its first row is fetched.

    - Main...

    January 15, 2012 at 3:53 pm

    #1433865

  • RE: Query Plan Execution Order

    SQL Kiwi (1/13/2012)

    So, person D (the stream aggregate) starts work first.

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

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

    So,...

    January 15, 2012 at 3:38 pm

    #1433864

  • RE: Query Plan Execution Order

    SQL Kiwi (1/13/2012)

    Sergiy (1/13/2012)

    How stupid does it sound?

    I don't find the analogy useful at all, to be honest.

    Really?

    What is off in this analogy?

    Now you would argue that...

    January 15, 2012 at 3:33 pm

    #1433863

  • RE: Query Plan Execution Order

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

    January 13, 2012 at 4:02 pm

    #1433589

  • RE: Query Plan Execution Order

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

    January 13, 2012 at 6:48 am

    #1433198

  • RE: Query Plan Execution Order

    SQL Kiwi (1/12/2012)

    You seem to be assuming (among many things!) that the scan completes before the join starts.

    I'm not assuming anything.

    I state what I see from the Profiler...

    January 13, 2012 at 1:59 am

    #1433063

  • RE: Query Plan Execution Order

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

    January 12, 2012 at 10:53 pm

    #1433022

  • RE: Query Plan Execution Order

    SQL Kiwi (1/12/2012)

    You really need to read those articles I linked to, to clarify your thinking here.

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

    Some of them...

    January 12, 2012 at 10:43 pm

    #1433020

  • RE: Query Plan Execution Order

    Here is the full execution tree for my batch:

    StmtText ...

    January 12, 2012 at 10:21 pm

    #1433017

  • RE: Query Plan Execution Order

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

    January 12, 2012 at 10:00 pm

    #1433008

Viewing 15 posts - 2,251 through 2,265 (of 6,036 total)