Interesting article.

I have index with 3 columns.

I get Index Seek with 2 columns in Seek Predicates.

And one column in Predicates: [T_Encounter].[sysDeleted] as [e].[sysDeleted]='N'

There are no hidden implicit conversions. sysDeleted...