title: Can I put a Clustered ColumnStore index on a table with NVARCHAR(MAX) fields?
body: <p>I have a table with 200 GB data in SQL Server 2016. So I am planning to apply Clustered ColumnStore in that table for disk compression and as well as better performance.</p>
  
  <p>But the problem is under that table there is one column which datatype is NVARCHAR(MAX), and columnstore indexes don't support that datatype.</p>
  
  <p>So what I am thinking is to change the datatype from NVARCHAR(max) to any other datatype which at least accept 81446 characters in the same column. </p>
  
  <p>I have tried some other datatypes available in SQL like VARCHAR(8000) but what its doing is removed other data which is after 8000 characters. </p>
  
  <p>I also tried text. But again in Text there is columnstore not applicable becuase of limitation.</p>
  
  <p>So could you please give me any idea what datatype I have to use. Or is there any other way to apply ColumnStore index in the same table?</p>