• Aside what Gail has said check the index id for the object. If its a heap then it will naturally contain some fragmentation.

    The page allocation marker is 8 pages, any allocations over that will use uniform extents. This is detailed on msdn, sorry but I don't have link at present.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉