Andy Brownsword moves an expression:
Computed columns allow us to bake logic into our schema. I find particular use for these when reviewing or optimising established solutions where you spot the quirky ways the data is being used.
Here I want to demonstrate 3 symptoms and show how different implementations of computed columns solve them.
Click through for the technique. It certainly won’t solve every performance problem relating to non-SARGable functions, but it does work pretty well on specific classes where you have limited control over the code.