CREATE NONCLUSTERED INDEX [_dta_index_dClientCode_16_437576597__K7_K3_1] ON [dbo].[dClientCode]

(

[ClientGenericId] ASC,

[Code] ASC

)

INCLUDE ( [ClientCodeId]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = ON) ON [Data_Data]

Use online= off recommended,some indexes will not create with online option ON