The statement "Because we know that SQL Server ignores NULL values when it constructs an INDEX" is incorrect.

SQL Server DOES index NULLs.

The CTE is not required. Simply adding...