Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Heaps Expand / Collapse
Author
Message
Posted Tuesday, May 3, 2011 10:44 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 1:59 PM
Points: 34,363, Visits: 18,582
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
Posted Tuesday, May 3, 2011 11:36 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 15,501, Visits: 13,163
Nice question! You really had me in doubt, as 4 seemed a too easy answer



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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1102866
Posted Wednesday, May 4, 2011 12:38 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, September 18, 2016 8:42 PM
Points: 665, Visits: 383
Good question Steve! 4 seemed too obvious to me as well.

Post #1102888
Posted Wednesday, May 4, 2011 2:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 8:46 PM
Points: 2,333, Visits: 3,896
Thank you Steve.

M&M
Post #1102924
Posted Wednesday, May 4, 2011 5:27 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 13, 2016 4:04 AM
Points: 3,358, Visits: 1,552
Thanks for the question. I dithered a little as well, before selecting the "obvious" answer of 4. A good, non-trick question.
Post #1103000
Posted Wednesday, May 4, 2011 6:49 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 19, 2016 9:20 AM
Points: 386, Visits: 630
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
Posted Wednesday, May 4, 2011 7:21 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 1:59 PM
Points: 34,363, Visits: 18,582
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
Posted Wednesday, May 4, 2011 7:45 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 11:49 AM
Points: 671, Visits: 489
Good question Steve.
Post #1103126
Posted Wednesday, May 4, 2011 7:47 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 30, 2016 1:03 PM
Points: 1,107, Visits: 2,123
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
Posted Wednesday, May 4, 2011 7:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 4, 2015 11:45 AM
Points: 77, Visits: 130
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse