NTEXT vs NVARCHAR(MAX) in SQL 2005

I recently profiled a sproc that makes heavy use of the TSQL SUBSTRING function (hundreds of thousands of times) to see how it performs on a SQL 2005 database compared to a SQL 2000 database. Much to my surprise the SQL 2005 database performed worse…dramatically worse than SQL 2000. After much researching it turns out … Read more NTEXT vs NVARCHAR(MAX) in SQL 2005