I use 255 because that is the max that a text form field will take. On Wed, May 5, 2010 at 2:43 PM, Michael Dinowitz <[email protected]> wrote: > > In MS SQL 2000, is there an optimal size for varchars? Specific size > chunks? I'm looking at a size over varchar(250) and the better the > better. > 255? > 256? > 512? > something else?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3341 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
