blogs.msdn.com blogs.msdn.com

Lesson Learned #76: The strange case between an indexed view and date type conversion

Hello Team, 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 ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...