Just a speculative question really, more in hope than expectation. I have a pretty standard DAC setup with a few custom subject areas and an execution plan consisting of these custom subject areas and a couple of vanilla ones. Up till now all has been fine, but after the last execution plan build, a large number of indices have suddenly been affected by the associated columns being marked as inactive, but not the indices themselves.
This then causes the index creation to fail in the ETL as no column is specified. A single new task was added to the SA and execution plan, and it isn't one of the ones affected by this issue.
It's so weird I suspect paranormal activity, has anyone seen this before?