Post reply

Table space usage 3

  • December 1, 2011 at 9:38 pm

    #260845

    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/

  • December 2, 2011 at 1:08 am

    #1415737

    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.

  • December 2, 2011 at 1:16 am

    #1415739

    Easier than your last question Hugo!

  • December 2, 2011 at 1:42 am

    #1415742

    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

  • December 2, 2011 at 3:45 am

    #1415784

    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!

  • December 2, 2011 at 4:31 am

    This was removed by the editor as SPAM

  • December 2, 2011 at 4:51 am

    #1415805

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

  • December 2, 2011 at 5:33 am

    #1415822

    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

  • December 2, 2011 at 6:52 am

    #1415852

    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

  • December 2, 2011 at 7:39 am

    #1415888

    Great question.

    Thanks,

    Matt

  • December 2, 2011 at 7:41 am

    #1415890

    Great question, thanks Hugo.

  • December 2, 2011 at 7:58 am

    #1415906

    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.

  • December 2, 2011 at 8:43 am

    #1415951

    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

  • December 2, 2011 at 8:48 am

    #1415959

    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.

  • December 2, 2011 at 9:09 am

    #1415992

    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