December 12, 2015 at 11:03 am
Comments posted to this topic are about the item Big plans
December 14, 2015 at 6:22 am
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:
December 14, 2015 at 10:52 am
Interesting question Hugo. I don't think I have seen any others related to this before on here. Thanks for the info!
December 14, 2015 at 11:08 pm
This was removed by the editor as SPAM
December 15, 2015 at 5:17 am
Yeah, I guessed as well. Thanks for another thought-provoking question.
December 15, 2015 at 6:35 am
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!
December 15, 2015 at 12:43 pm
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.
December 16, 2015 at 2:34 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 18, 2015 at 8:13 am
Fascinating question, as always, Hugo. Thanks!
December 20, 2015 at 3:02 pm
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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply