title: Issue After Converting Table Column From "Text" to Varchar(max)
body: <p>I had a table called Person with column PersonDescription which was of type "text".
  I had issues with updating this column so i ran the script </p>
  
  <blockquote>
    <p>ALTER TABLE dbo.Person ALTER COLUMN
    PersonDescription VARCHAR(max)</p>
  </blockquote>
  
  <p>to change the column to be 
  varchar(max). This was all fine and ran instantly. However now i have noticed that anytime i try to update this column then It is taking up to 3-4 mins to execute. Query is </p>
  
  <blockquote>
    <p>Update Person set PersonDescription
    ='persons description' where personid=18</p>
  </blockquote>
  
  <p>After this update is ran then it executes instantly. This is all fine but when this change goes to production then this table has a million records so every person that logs in is going to timeout when this runs. Can anyone tell me how i can prevent this. Is there another script etc that i need to run. After running the update i saw that Statman runs on sqlserver which is what is taking the time.</p>
  
  <p>thanks
  Niall</p>