According to most of what I've read Max types are supposed to behave much better than TEXT etc
But be aware that if you use the SQL Native Client with SPT you will have problems. Varchar(max) will return no data. ODBC driver ( 'SQL Server' ) works fine.
>I have a filed that was defined as varbinary(2400). Then there was some changes to the project so now I need the field to be able to hold up to 7700 bytes. If I change the field to varbinary(7700), I will violate the maximum rowsize (8060 bytes) (because there are other fields in the table and they add up to a lot more than 360 bytes).
>
>So I guess I have to change the field type to varbinary(max). Before SQL2005 I tried not to use IMAGE or TEXT types unless I really had to, and that is kind of how I feel about varbinary(max).
>
>Is there anything I should watch out for when using varbinary(max)?
>Does varbinary(max) reduce performance a lot?
>
>Any other thoughts on the issue are also welcome.
>
>Thanks,
>Einar
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.