it's not so easy as you might think. Greg Low had a note on it few days ago

https://blog.greglow.com/2019/07/25/sql-think-that-varchar-characters-if-so-think-again/

very interesting, indeed.

at least with additional non-clustered indexes you can use different, filtered ones. one for the hot data, another for the cold data. you will need to be creative...