• Quick message to those who arrive here: I am aware that this question involves a lot of calculations - much more hard work than normal questions. So my compliments on all your hard work, and I hope it paid off by earning you a point.

    My question is: would you like a few more questions of this kind, or would submitting the rest of the questions I was planning expose me to death threats, stale fruit, or lots of boo-ing and hissing?

    This is a serious question. If the majority feels that the QotD should not involve that much work, I will not submit the other similar questions I was planning.

    (For full disclosure, my plan was to have one or two more questions to simply calculate disk space, then take it to the next level and use this knowledge as a foundation to calculate the amount of reads required for certain queries and execution plans, which should help you understand the optimizers' choices and the usefulness (or lack thereof) of indexes).


    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/