Post reply

varchar(Max)

  • April 13, 2006 at 2:08 pm

    #167695

    New varchar(Max).  Treated as a TEXT field, or not??

    If varchar(Max) is just like varchar(50), then why not varchar(max) everything.  Other than modeling philosophies, and gui/size issues, are there any major problems with using varchar(max). Microsoft said if the size was under 8000, it is treated similaring to other varchars.

    Anyone with experience on these???

    Roger Bundy

  • April 13, 2006 at 2:21 pm

    #632525

    I guess it really depends on the context of how you intend to use it in order to best answer your question.

  • April 17, 2006 at 8:35 am

    #632764

    You are more likely to get optimum execution plans in some situations if varchar fields are declared with expected max values, rather than just using 255 or 8000 or MAX for everything.  If you use MAX for everything, it has to believe you and prepare by allocating extra memory for buffers.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply