Heaps

Question

Heaps

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

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

Koen Verbeeck SSC Guru Points: 259197 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: 739542 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 SSCommitted Points: 1527 More actions · Answer 7

Surii

SSCommitted

Points: 1527

May 4, 2011 at 7:45 am

#1319765

Good question Steve.

jeff.mason SSCrazy Eights Points: 9635 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: 281344 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: 739542 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.

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 15

SanDroid (5/4/2011)
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.

LOL... made me pause, too! It's great to challenge assumptions. Another great question, thanks!

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems