Duplicate index - Same key, one with INCLUDE columns, which one to drop?
I believe the IndexInclude will satisfy anything that would've used IndexNoInclude right? since the Keys are exactly the same


Are they the same? Maybe I am misreading the output, but it certainly looks like IndexNoInclude has an extra key column: [ID] NUMERIC.

You should review your queries to see which of the 6 INCLUDE columns are actually being referenced / used. You could likely get away with "merging" the two indexes such that the remaining index has both key columns and between 1 and 6 of the INCLUDE columns.