Skip to main content

Posts

Showing posts from November, 2008

Replace ntext with n/varchar(MAX)

Starting with SQL Server 2005 replace ntext with more efficient varchar(max). varchar(max) and nvarchar(max) store data fields smaller than 8,000 characters in the table rather than as a large object (LOB/BLOB).

Beware when upgrading data currently stored as NText as it will remain a LOB until you run an update query setting the value equal to the current value, e.g.
UPDATE testTable SET testText = testText
Full details and thanks go to Making Stuff Faster