Was hoping that there was a SQL Database option to ignore Unicode formatted statements.

Yes, there is another index that got missed when I did the cut and paste as it was off the window along with the grant select statements.

And if the primary...

That's a great point Jeff ! I will make that correction.

Both query plans actually are using Index Seeks, the Unicode is doing a clusterd Seek. My bad for miss...

The difference in the execution plans is the use of the Conver_Implicit on the Unicode query.

They are both using Index Scans, It is the Conver_Implicit that is consuming the CPU...