title: Indexing an NVARCHAR(MAX) column in SQL Server
body: <p>When I define a column as <code>NVARCHAR(MAX)</code>, I can't index that column. But I certainly can't define the column as <code>NVARCHAR(4000)</code> since I assume the data string will be longer sometimes.</p>
  
  <p>Can anyone suggest how to index the column with <code>NVARCHAR(MAX)</code> data definition or is it possible to increase the length from 4000 to more?</p>