Activity overview
Latest activity by shawn.mayer
I too was unable to replicate this on a new database so I investigated further. One of the databases was set to compatibility level 90 and the other 100. When I set them both to 100 the issue went away. / comments
I too was unable to replicate this on a new database so I investigated further. One of the databases was set to compatibility level 90 and the other 100. When I set them both to 100 the issue went ...
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...