Heaps

Question

Heaps

Steve Jones - SSC Editor

SSC Guru

Points: 736078
More actions
May 3, 2011 at 10:44 pm

#74220

Comments posted to this topic are about the item Heaps

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

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

scottm30 Ten Centuries Points: 1094 More actions · Answer 2

Good question Steve! 4 seemed too obvious to me as well.

M&M SSC-Insane Points: 21700 More actions · Answer 3

M&M

SSC-Insane

Points: 21700

May 4, 2011 at 2:24 am

#1319586

Thank you Steve. 🙂

M&M

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 4

Thanks for the question. I dithered a little as well, before selecting the "obvious" answer of 4. A good, non-trick question.

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 5

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

Steve Jones - SSC Editor SSC Guru Points: 736078 More actions · Answer 6

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.

Surii Default port Points: 1497 More actions · Answer 7

Surii

Default port

Points: 1497

May 4, 2011 at 7:45 am

#1319765

Good question Steve.

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 8

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.

Incindium SSC Veteran Points: 209 More actions · Answer 9

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?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

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

Steve Jones - SSC Editor SSC Guru Points: 736078 More actions · Answer 11

4 heap structures. If you read the reference, it states this.

Chris Umbaugh Ten Centuries Points: 1334 More actions · Answer 12

Good question. Thanks Steve.

Chris Umbaugh
Data Warehouse / Business Intelligence Consultant
twitter @ToledoSQL

Chris Houghton SSCrazy Points: 2557 More actions · Answer 13

Nice technical question Steve. Are some of these recent questions resulting from you studying for the MCM Certification?

SanDroid SSChampion Points: 10068 More actions · Answer 14

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.