Table space usage 3

  • Comments posted to this topic are about the item Table space usage 3


    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/

  • This is one of those questions that looks really easy, but obviously isn't judging by the number of people selecting the wrong answer! Mind you, maybe it's obvious to me because I come from a programming background, and have run into issues with packing stuff into a particular space before.

  • Easier than your last question Hugo!

  • Thanks for the question. I got an idea after referring the answer to your previous question 'Table space usage 2'.

    Looking forward for your next question on this interesting stuff :-).

    M&M

  • good question, hugo!!!

    thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • This was removed by the editor as SPAM

  • Great question. You got me on this one. -1 point for me.

  • Nice question. You go, Hugo!

    Seemed easy, but had to think a minute. Then realized that the "average" length was the key. Thanks.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Good question Hugo. Kept looking for the catch, and kept re-reading to find there is none:-P

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • Great question.

    Thanks,

    Matt

  • Great question, thanks Hugo.

  • Given the almost 50/50 split between right and wrong answers, I suspect most people are taking an educated guess at the answer (I know I did). The emphasis on the word EXACT made me suspect that the answer to this question was going to be no. Thanks for a good learning question.

  • Excellent question. A good one for Friday - nice and easy.

    I don't understand why so many people (184 out of 370 so far) got it wrong.

    It must seem blindingly obvious to anyone who has ever had to pack a collection of variously sized objects into a set of equally sized boxes that you can't tell the number of boxes needed from the average object size - and that isn't all that rare a domestic task. When packing to move house (or even for a family holiday) shuffling things between packing crates (or between suitcases) in order to fit more things in is surely a common experience?

    People who work with databases should of course know how to do worst case estimates on storage occupancy, so even if they haven't had domestic experience of putting vaious sized pakages into a uniform set of tubs they ought to get this one right. Although it maybe doesn't matter too much - the spread from best case via average case to worst case isn't all that enormous for the criteria given in the problem (unless my mental arithmetic is playing tricks on me).

    Tom

  • L' Eomot Inversé (12/2/2011)


    Excellent question. A good one for Friday - nice and easy.

    I don't understand why so many people (184 out of 370 so far) got it wrong.

    It must seem blindingly obvious to anyone who has ever had to pack a collection of variously sized objects into a set of equally sized boxes that you can't tell the number of boxes needed from the average object size - and that isn't all that rare a domestic task. When packing to move house (or even for a family holiday) shuffling things between packing crates (or between suitcases) in order to fit more things in is surely a common experience?

    People who work with databases should of course know how to do worst case estimates on storage occupancy, so even if they haven't had domestic experience of putting vaious sized pakages into a uniform set of tubs they ought to get this one right. Although it maybe doesn't matter too much - the spread from best case via average case to worst case isn't all that enormous for the criteria given in the problem (unless my mental arithmetic is playing tricks on me).

    An even better explanation. Thanks.

  • Thanks for the reminder Hugo.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 1 through 15 (of 23 total)

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