Today, it was my second case that I have found a thing that we need to remember with the definition of an indexed views. So, this is the history:
Our customer has the following table and indexed view definition:
CREATE TABLE [dbo].[Test](
[ID] [int] NOT NULL,
[Date_To_Text] [nvarchar](200) NULL,
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...