sqlquantumleap.com
Impact on Indexes When Mixing VARCHAR and NVARCHAR Types
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them is a JOIN or WHERE predicate / condition, as doing so will invalidate indexes. While…