Heaps

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Heaps

29 posts, Page 1 of 3

1 2 3 »»»

Heaps

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Tuesday, May 03, 2011 10:44 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

Comments posted to this topic are about the item Heaps

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1102848

Koen Verbeeck

Posted Tuesday, May 03, 2011 11:36 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,375, Visits: 6,472

Nice question! You really had me in doubt, as 4 seemed a too easy answer Smile

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1102866

scottm30

Posted Wednesday, May 04, 2011 12:38 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 13, 2012 3:26 PM
Points: 566, Visits: 341

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

Post #1102888

mohammed moinudheen

Posted Wednesday, May 04, 2011 2:24 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

Thank you Steve. Smile

Mohammed Moinudheen

Post #1102924

Duncan Pryde

Posted Wednesday, May 04, 2011 5:27 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 3,046, Visits: 1,307

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

Post #1103000

SQLBalls

Posted Wednesday, May 04, 2011 6:49 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:34 PM
Points: 385, Visits: 611

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

Post #1103055

Steve Jones - SSC Editor

Posted Wednesday, May 04, 2011 7:21 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1103096

Surii

Posted Wednesday, May 04, 2011 7:45 AM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, February 21, 2013 5:19 PM
Points: 658, Visits: 455

Good question Steve.

Post #1103126

jeff.mason

Posted Wednesday, May 04, 2011 7:47 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 06, 2013 6:51 AM
Points: 989, Visits: 1,790

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.

Post #1103129

Incindium

Posted Wednesday, May 04, 2011 7:54 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 10:29 AM
Points: 77, Visits: 120

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?

Post #1103136

« Prev Topic | Next Topic »

29 posts, Page 1 of 3

1 2 3 »»»

Permissions