• OK, let's find out what it really looks like; you can run DBCC IND on the index in question:

    dbcc ind ( { 'dbname' | dbid }, { 'objname' | objid }, { nonclustered indid | 1 | 0 | -1 | -2 } [, partition_number] )

    There will be a row for every page in the index so you might not want to take your largest index.

    Also, even though PAD_INDEX is depending on FILLFACTOR (and that doesn't seem to be set), check anyway:

    SELECT object_name(object_id), index_id, fill_factor, is_padded

    FROM sys.indexes

    WHERE object_id = sometable

    AND index_id = someindex

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei