• Jason-299789 (12/17/2012)


    By any chance did you update one or more of the XML columns, as these (from memory) are stored as LOB's so pointers would be created to them hence the extra 2.

    i am only updating [Title] and [Name] columns .

    When i do index rebuild ALTER INDEX [PK_Person_BusinessEntityID_bk] ON [Person].[Person_BK]

    REBUILD; after that sys.dm_db_physical_stats returns 3 rows for this PK. And yes i have 2 XML column in my table (see above table definition ) but NO update on these columns

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)