A practical use for filtered indexes
Finally there is a solution to having a unique column with NULL values in it. The answer is using SQL Server 2008 filtered indexes but there is a practical limitation as well. Continue reading A practical use for filtered indexes