So I hear sometimes that I should not use a clustered index on a wide column, mainly because it is being referenced in all other indexes.
When all my other indexes on this table include all other columns - is there still this (extra) penalty?
(This table has no external references on the clustered index by other tables)
For reference my table looks a bit like this:
PartOfNaturalKey1 int PartOfNaturalKey2 varchar(10) PartOfNaturalKey3 varchar(20) PartOfNaturalKey4 int Value varchar(10) LastChanged datetime2(7) Invalid bit
The Natural Key is unique and will (almost never) change.