• Hi,

    Interesting question!

    The expected one data page will be listed after rebuilding the index on the table.

    alter index PK_Test on dbo.Test rebuild

    dbcc ind ('TestDB','Test',1)

    Thanks,

    IgorMi

    Igor Micev,My blog: www.igormicev.com