SQL Server Performance

varchar(max) and FTS

Discussion in 'SQL Server 2005 General Developer Questions' started by Arhamg, Jun 17, 2008.

  1. Arhamg New Member

    Hi,
    I have a made a full text index on column in a table having only 2 cols in all(one phrase(varchar(4000)) and second Id).
    Now i want to change that col to varchar(max).
    Query 1: How will it affect my FTS(if at all it'll affect)?
    Query 2: Any drawbacks of using varchar(max) cols apart from that it stores the data off-row incase the row size goes beyond 8060 bytes?
  2. satya Moderator

Share This Page