Satnam Singh
Hall of Fame
Points: 3542
More actions
August 16, 2012 at 10:55 pm
#392970
Team,
Is UPDATE STATISTICS operation on columns of NTEXT Data Type Dead Slow. I have few statistics in the database which belongs to the NTEXT data type and they take more than hours to get updated.
With Thanks,
Satnam
durai nagarajan
SSCoach
Points: 15775
August 20, 2012 at 8:24 am
#1527628
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
RegardsDurai Nagarajan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply