I'm trying to define an index to identify rows that need to selected by an overnight process. In a past life I would have defined a char(1) field which would have been populated with either a Y or a NULL. The DBMS I was using would ignore the NULL and only create index entries for the Y. This was the most efficient way of identifying a small subset of data in a large table.
Does SQL Server work the same way?
Is there a better way of achieving this in SQL Server?