Custom Index for Not Null Values Only
1. Is it possible do define an index like that :
create index UIX on MyTable (Column1) where Column1 is not null
2. What happens if we add an index on a property that is NOT required, meanning that not all records will be indexed because we do not allow null subscripts ?