sqlhints.com
SET Options with their setting values required while working with filtered index
While dealing with filtered index following Six SET option’s value should be set to ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL…