• Scott, the table is not in the primary file group and the database has about 20 data files spread over numerous Netapp Luns if that's what you mean

    CREATE TABLE [dbo].[FILE_RECORD](

    [FILE_RECORD_ID] [int] IDENTITY(1,1) NOT NULL,

    [LOGICAL_RECORD_DESCRIPTOR_REFERENCE_ID] [varchar](50) NOT NULL,

    [RAW_CONTENT] [varchar](3000) NOT NULL,

    [CREATED_DATE_TIME] [datetime] NOT NULL,

    [LINE_NUMBER] [smallint] NULL,

    [MESSAGE_ID] [int] NULL,

    [FILE_ID] [int] NULL,

    [CONCRETE_TYPE] [varchar](150) NOT NULL,

    [LAST_MODIFIER] [int] NOT NULL,

    [LAST_MOD_DATE_TIME] [datetime] NOT NULL,

    [TRANS_SEQ_NUM] [smallint] NOT NULL,

    [MESSAGE_DIRECTION] [char](8) NOT NULL,

    [MESSAGE_ERRORERROR_ID] [int] NULL,

    [ACCOUNT_DATA_ID] [int] NULL,

    [RECORD_CONTEXT] [varchar](10) NOT NULL,

    [FILE_DESCRIPTOR_ID] [int] NULL,

    [FILE_RECORD_STATUS] [varchar](50) NULL,

    [CHECKSUM] [char](48) NULL,

    CONSTRAINT [FILE_RECORD_PK] PRIMARY KEY CLUSTERED

    (

    [FILE_RECORD_ID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [CM_Data]

    ) ON [CM_Data]

    END