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