Indexes Blew up after migration from SQL 2000 to SQL 2005
i migrated sql 2000 sql 20005 client using backup/restore method. evverything perfect until weekend. on weekend had scheduled rebuild index job. after (i presume caused issue) database blew 18gb 80gb! 65% index. main issue table mhgroup.docmaster holds documents. (this document management system intervowen). basicly there 5 million records , 16gb of data , 46gb of indexes. table huge , there 33 non-clustered indexes. 1 clustered index created via key constraint. suspecting forwarded records wrong. thoughts?? below table sctipted. use [mbdocs] go /****** object: table [mhgroup].[docmaster] script date: 09/02/2009 10:49:32 ******/ set ansi_nulls on go set quoted_identifier on go set ansi_padding on go create table [mhgroup].[docmaster]( [docname] [varchar](254) null, [docnum] [float] not null, [docsize] [float] null, [editwhen] [datetime] null, [docinuse] [char](1) null, [entrywhen] [datetime] null, [editprofilewhen] [datetime] null, [indexed] [char](1) null, [ve...