Table space usage 3

  • Thanks Hugo 🙂

  • Great question. I debated for awhile, completely forgot the way data is stored in pages, and got the answer wrong. But I really enjoyed reading why 🙂

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • Ah, correctly answering one of Hugo's questions is a great start to the weekend! I will savor this feeling, as it may very well months until it happens again.

    Great question, Hugo.

  • Thanks, all, for the kind words. I figured a not-too hard yes/no question would make for a nice change of pace. (It being scheduled on a friday is not my doing, though).

    The next question in this series (which will be a tough one, I hope) is still being prepared, but I do have another (unrelated) question scheduled for next week - so brace yourselves! 😛


    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/

  • Nice question, thanks!

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

  • Thanks for the question Hugo. I thought it might be trick and almost talked myself out of the correct answser.

    http://brittcluff.blogspot.com/

  • Disclaimer : Please excuse me for the delayed attempt for these questions

    I have attempted "table space usage" questions 1,2 and 3 in sequence, but the answer for question 3 is mentioned in discussion of question 2 :-).

    http://www.sqlservercentral.com/Forums/Topic1206403-1328-3.aspx

    "In the real world, one would never calculate the data size to the exact page number."

  • pmadhavapeddi22 (3/7/2014)


    Disclaimer : Please excuse me for the delayed attempt for these questions

    I have attempted "table space usage" questions 1,2 and 3 in sequence, but the answer for question 3 is mentioned in discussion of question 2 :-).

    http://www.sqlservercentral.com/Forums/Topic1206403-1328-3.aspx

    "In the real world, one would never calculate the data size to the exact page number."

    I think that quote in the discussion on question 2 is about the lack of practical application. And that is true. In a real database, I want to have a good estimate about the data size I can expect, but I truly am not bothered by just a few pages more or less. However, the table designs I used in question 1 and 2 were such that an exact calculation is at least possible.

    For question 3, the table design is such that based on the given information it is impossible to do this exact computation - even if you would want to.


    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/

  • Thanks for the explanation and for all the detailed and brilliant knowledge/analysis.

Viewing 9 posts - 16 through 24 (of 24 total)

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