How to convert ntext to nvarchar(max) in SQL 2005 – the right way

Written by Deepak Vasa on August 5th, 2008

Today, I found this very very useful blog on how to convert ntext fields to nvarchar(max) in Sql 2005. Apparently when converting a field from ntext to nvarchar(max), SQL Server does not change the internal structure and this is bad as the performance slows down significantly. However the following blog has got a simple fix to make SQL do the correct change.