Using varchar(MAX) vs TEXT on SQL Server
I just read that the VARCHAR(MAX) datatype (which can store close to 2GB of char data) is the recommended replacement for the TEXT datatype in SQL Server 2005 and Next SQL SERVER versions. If I want to search inside a column for any string, which operation is quicker? Using a the LIKE clause against a … Read more