• Table Size: 2 GB

    Index: cluster index on identity column, three non cluster index

    index size: 3 GB

    cluster index insert

    row count:38968909

    Soooo, you have just 2GB of data yet 3 NC indexes total up to 3GB? Did you perchance use DTA and now you have 3 indexes which each have 50-75% of the columns in the table included in them??

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service