The short answer is yes For the longer answer, let's start with the follow-up question: Do my end users care that it's slowing my SQL Server ... table with nine non-clustered indexes on it there ...

This limitation is given the fact that the boot page stores Meta information like the current version, database ID, checkpoint LSN, etc. Non-clustered index corruption: this type of corruption is ...