Posts
Sort by recent activity
Nonclustered Index not detecting Where is not null
I have an index that is created like so:
CREATE UNIQUE NONCLUSTERED INDEX [UNQ_table] ON [dbo]. ([column]) WHERE ([column] IS NOT NULL)
SQL Compare doesn't seem to be detecting the where is not nul...