I have a column with data type
nvarchar(max) and I wold like to index this. However, since it's too big it's not possible. So I figured I could create a persisted computed column based on that column with the formula:
However this column also gets a data type of
nvarchar(max) so I can't create an index for it. Is it possible to index it somehow without using a full-text index?