What is the best way to store a large amount of text in a SQL server table?

sql-server

Solution

In SQL 2005 and higher, VARCHAR(MAX) is indeed the preferred method. The TEXT type is still available, but primarily for backward compatibility with SQL 2000 and lower.

Problem

What is the best way to store a large amount of text in a table in SQL server? Is varchar(max) reliable?

Original source