Home Forums SQL Server 2005 Development Difference between varchar(max) and varchar(8000) RE: Difference between varchar(max) and varchar(8000)

  • February 4, 2009 at 6:12 am

    #937865

    charlesz (2/3/2009)

    As I said in previous post, for a column mostly stores very short strings, the overhead of Varchar(MAX) is significant.

    There is no overhead when the "string size" is less than 8000 bytes.

    N 56°04'39.16"
    E 12°55'05.25"