CREATE INDEX [IX_EMPR_Parsed_Includes] ON [EMDR].[T_EMPR] ([Parsed])  INCLUDE ([Zipped]) WITH (FILLFACTOR=100, SORT_IN_TEMPDB=ON)
GO

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[EMDR].[T_EMPR]') AND name = N'IX_EMPR_MO_DOC')
DROP INDEX [IX_EMPR_MO_DOC] ON [EMDR].[T_EMPR]
GO
