>At some point he tried this option
>
>
>EXECUTE sys.sp_tableoption
> @TableNamePattern = N'dbo.TestMAXOOR',
> @OptionName = 'large value types out of row',
> @OptionValue = 'true'
>;
>SELECT large_value_types_out_of_row
>FROM sys.tables
>WHERE [schema_id] = SCHEMA_ID(N'dbo')
>AND name = N'TestMAXOOR'
>;
>
>
>to store varchar(max) data out of the row. However, later in the article he doesn't recommend this option because of the big memory grant in TempDB. If you're not using ORDER BY in your query, it may be not that helpful.
>
>You may leave the comment into his blog post to see what he says and also alternatively try
http://www.sqlsentry.com/plan-explorer/sql-server-query-view.asp which has an option of uploading masked version to the site for Experts Analysis (including Paul White who wrote that article).
Thanks, I'll adjust to use a flag field to detect if I should enable a link in my view column when showing the list. So, as I will use a Boolean indexed field in the SQL, I will no longer need to use the Varchar(MAX) and that will resolve the issue.