Sometimes I require unique values in a column that allows nulls.
CREATE UNIQUE NONCLUSTERED INDEX IndexName ON dbo.TableName(ColumnName) WHERE ColumnName IS NOT NULL
Update: SQL Server Management Studio has this functionality built into the Index Properties dialog.
([ColumnName] IS NOT NULL)