blog.philipsymons.com
Sql Server Filtered Index as a Unique Constraint on a Specific Value
Indexes often double as constraints. Each combination of values must only appear once among the columns of an index defined as UNIQUE. The “filtered” index allows some refinement. Suppo…