Table Access Order

  • Comments posted to this topic are about the item Table Access Order

  • Thanks for another superb question Paul.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (9/19/2011)


    Thanks for another superb question Paul.

    Thanks for leaving a comment - I had completely forgotten this was scheduled for today!

  • SQL Kiwi (9/19/2011)


    SQLRNNR (9/19/2011)


    Thanks for another superb question Paul.

    Thanks for leaving a comment - I had completely forgotten this was scheduled for today!

    The timing of the question is good. It gives me more info to research for an article I have been stumped on for a few months.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Even though i got it right, I wasn't 100% sure that it wasn't answer C. Great information!


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • Nice to see questions like this 🙂

    M&M

  • Good question - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • Nice Question!!!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Thank you very much for such an interesting question. Got the old grey matter going!

    Bex

  • This was removed by the editor as SPAM

  • I got it wrong today ... as I completely forgot the role of "HASH" in the join statement. Grrrrr ....

  • Not only a great question, but a superb explanation. Thanks.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Good question, had to think a little. I was pretty sure it was A especially since there were no rows.

    http://brittcluff.blogspot.com/

  • Very interesting question. Thanks for the explanation.

  • Great question Paul!!!

    Thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

Viewing 15 posts - 1 through 15 (of 35 total)

You must be logged in to reply to this topic. Login to reply