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