title: SQL Server - Better Data type to store large string value
body: <p>we have a database table which has around 200,000 records. which includes 3 ntext columns, which hold string data with length vary from 4000-70000.  but a mere selection on the table takes more than 1 minute to return data. and even using where condition, and indexes to select 12000 records for a condition it takes 40 sec.</p>
  
  <p>so we decided to change those data types to nvarchar(max), but still did not notice a major difference, as it would store data out of the row since its too long. is there any better way i can improve this performance of my table ?</p>