Hello,
I have this problem.
At monday found this, so drop and recreate index, then execute dbcc check and without problem.
Today this problem appear again. Is possible to do some another action? It can be with data what are inserted there ?
This index is concists of from big columns ( 4x nvarchar(150), one 250 then 100, 80 and some int )
is possible to do some next action?
If you add up the width of all those columns (especially taking NVARCHAR as 2 bytes per character), you have greatly exceeded the maximum byte count for an index key. Figure out what the key for the index actually needs to be and just INCLUDE the other columns and then you won't have such problems.
Hello,
I was thinking about this, because when I dropped and recreated that was warning with max values, so my thinking was about that will se problem during update/insert some large data or something.
The drop, recreate was ok, but if something happen again I need to discuss with owner of db about change this index.
Thanks for advices 🙂