T-SQL Enhancements

Varchar(max), Varbinary(max)
In SQL 2000, fields over 8,000 characters used Text, Image but that involved a different programming style than smaller fields.

Now fields of type char, varchar, binary, varbinary can hold up to 2 GB storage with same programming style as small fields.