title: Best datatype for SQL table with lots of long text fields
body: <p>I have the following table in a SQL Server 2008 database with lots of long varchar fields for text descriptions. I want to know what is the best datatype to use for these. Currently I'm using varchar with 2000 character limit but this might cause problems if people need to add more text. Is there a problem using TEXT more than once in a table? What do you suggest?</p>
  
  <pre><code>Table
   name varchar(250)
   description1 varchar(2000)
   description2 varchar(2000)
   description3 varchar(2000)
   description4 varchar(2000)
   description5 varchar(2000)
  </code></pre>