• what is the table size (total records) and no of tables affected by ntext in the statistics update?

    read the link below might help..

    http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx

    Regards
    Durai Nagarajan