We have an query that would benefit from a covering index but one of the columns that would be returned is a NTEXT data type. I know this can't be added to the index and I also know it would be good to convert the column to nvarchar(max) however as this is a 3rd party app (its Microsoft Dynamics!) we are at present unable to do this.
The issues looks to be all the lob logical reads that are being performed as part of a RID lookup. Is there any way of speeding this up?