<< How to Fix "The Project file '' has been renamed or is no longer in the solution." | Conversion Between MBps, Mbps, Kbps, KBps >>

NTEXT vs NVARCHAR(MAX) in SQL 2005 and 2008

by Al Beecy February 17, 2009

Short answer:

Unless you are expect to have a lot of rows where the text is fairly large, NVARCHAR(MAX) is the way to go.

The reason is that it stores the text in row by default. NTEXT stores the text in LOBs by default.

Also, NTEXT is deprecated in SQL2005 and forward.

Long answer:

See this blog article for a complete analysis: Making it Faster.

Applies to: SQL Server 2005, SQL Server 2008

a584dc76-a2b0-419d-bbcd-d9c97e401ee1|1|4.0

Tags: sql server 2005, sql server 2008

Script SQL Server 2005 and 2008 DiagramsA script that will script SQL Server 2005 and 2008 diagrams so that you can copy them to a new DB.How to encrypt a SQL Server stored procedureHow to encrypt a stored procedure in SQL Server 2005.Grouping SQL Server Data by Time with a Temp TableHow to group SQL Server data by date/time using a temporary table.

Comments