Table Access Order

  • Paul White

    SSC Guru

    Points: 150442

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

  • SQLRNNR

    SSC Guru

    Points: 281243

    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

  • Paul White

    SSC Guru

    Points: 150442

    SQLRNNR (9/19/2011)


    Thanks for another superb question Paul.

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

  • SQLRNNR

    SSC Guru

    Points: 281243

    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

  • Robert Davis

    One Orange Chip

    Points: 28027

    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]

  • M&M

    SSC-Insane

    Points: 21699

    Nice to see questions like this 🙂

    M&M

  • Stuart Davies

    SSCoach

    Points: 18878

    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

  • free_mascot

    One Orange Chip

    Points: 27168

    Nice Question!!!

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

  • Bex

    SSCrazy

    Points: 2377

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

    Bex

  • This was removed by the editor as SPAM

  • Kwex

    Default port

    Points: 1407

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

  • Thomas Abraham

    SSChampion

    Points: 10761

    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

  • Britt Cluff

    SSCertifiable

    Points: 5083

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

    http://brittcluff.blogspot.com/

  • Cliff Jones

    SSChampion

    Points: 10517

    Very interesting question. Thanks for the explanation.

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    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