May 3, 2011 at 11:36 pm
Nice question! You really had me in doubt, as 4 seemed a too easy answer
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 4, 2011 at 12:38 am
Good question Steve! 4 seemed too obvious to me as well.
May 4, 2011 at 2:24 am
Thank you Steve.
M&M
May 4, 2011 at 5:27 am
Thanks for the question. I dithered a little as well, before selecting the "obvious" answer of 4. A good, non-trick question.
May 4, 2011 at 6:49 am
Good question, I know instinctively that each object get's a new set of allocation Units per partition, but I normally do this with clustered indexes, and not heaps.
I went out and did this on a test db real quick to validate what already had known, it's questions like this that help us validate book knowledge by looking in all the little knooks and cranies.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
May 4, 2011 at 7:22 am
Glad it went over well. This one was hard to write without trying to trick people. I wanted it to make you think, but be solvable without misleading anyone.
May 4, 2011 at 7:45 am
Good question Steve.
May 4, 2011 at 7:47 am
I knew it was either 1 or 4, but I wasn't sure whether the heap would span the partitions or not. So I took a stab at 1 and was wrong. I was just too sure that there was a trick there and dug in too deep, because my gut was telling me 4.
May 4, 2011 at 7:54 am
So the clustered index bit of the question was just a decoy huh? Either way there will be 4 structures whether it is 4 heaps or 4 b-tree's right?
May 4, 2011 at 7:58 am
Good question
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
May 4, 2011 at 8:12 am
4 heap structures. If you read the reference, it states this.
May 4, 2011 at 8:46 am
Good question. Thanks Steve.
Chris Umbaugh
Data Warehouse / Business Intelligence Consultant
twitter @ToledoSQL
May 4, 2011 at 9:08 am
Nice technical question Steve. Are some of these recent questions resulting from you studying for the MCM Certification?
May 4, 2011 at 9:15 am
Koen Verbeeck (5/3/2011)
Nice question! You really had me in doubt, as 4 seemed a too easy answer
I felt the same way, but knew the answer was 4.
I hope that is why over 40% are getting the wrong answer.
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy