Big plans

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Comments posted to this topic are about the item Big plans


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • sknox

    SSChampion

    Points: 12196

    Interesting. I haven't studied the plan cache in detail, so I guessed the answer.

    There's a typo and a math error in the paragraph about query size:

    There is a limit on the size of the query, which is 65,536 * network packet size. The default network packet size if 4,096 bytes (resulting in a maximum query size of 256MB), but the network packet size can be adjusted to a maximum value of 32,767 bytes (for a maximum query size of 2048GB)

    65,536 x 32,767 is approximately 2048 MB, or 2 GB, which (hopefully) is more than enough for any query. A 2 TB query would be truly frightening! :w00t:

  • Ken Wymore

    SSCoach

    Points: 16314

    Interesting question Hugo. I don't think I have seen any others related to this before on here. Thanks for the info!

  • This was removed by the editor as SPAM

  • Ed Wagner

    SSC Guru

    Points: 286950

    Yeah, I guessed as well. Thanks for another thought-provoking question.

  • Megistal

    SSCrazy Eights

    Points: 8787

    I definitely learned something this morning, however I often ask myself "what/how/why that question emerged in the first place in the mind of that person?". What sparkle the idea? Often funny to hear; if you'd like to share Sir Kornelis!

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Megistal (12/15/2015)


    What sparkle the idea? Often funny to hear; if you'd like to share Sir Kornelis!

    I am preparing a course for Pluralsight that will have hours and hours of in-depth information on execution plans. I wanted to include a demo that shows the audience that there is no free lunch - use a large amount of constants in the query, and they will have to be stored *somewhere*.

    Then when I was trying to come up with good ideas for QotD submissions, I remembered that demo code and decided to use it here as well, for a question that is a bit more lighthearted and fun than the others I submitted at the same time.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Koen Verbeeck

    SSC Guru

    Points: 258854

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • stephen.long.1

    SSCrazy

    Points: 2568

    Fascinating question, as always, Hugo. Thanks!

  • patricklambin

    SSCrazy Eights

    Points: 9964

    A good question and I was lucky to find the good choice ( maybe the other choices did not seemed very attractive ).

    Thanks for it and for your explanations ( short this time ).

    I will download your "big" plan to-morrow ( it's 23:00 for me ) to study it.

    Have a nice day

Viewing 10 posts - 1 through 10 (of 10 total)

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