Reitse Eskens runs into an issue with computed columns:
I got a question some time ago about a query not performing. There seemed to be an issue with SQL not using the best possible index. Now this issue is already vague and it took me some time to understand what was happening but with a simple demo I could replicate some of the issues.
Read on to learn what the problem was, as well as Reitse’s solution for it.