April 1, 2016 by Kenneth Fisher
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t wait until the time I usually post.
So if you take the x character of the first character column of each table (where x is object_id % len(column) ), merge them all together and sort based on the last int column then about half way down you will see the following:
I did some tests and from what I can tell if you use this option on any query it causes the memory grant to be exactly 640kb.
Not really all that useful but I’m going to keep looking and see if I can find anything else.