[AccessD] Field Sizes

No it is NOT best practice. There are performance hits with varchar columns
that do not exist with char columns. I will shortly post a benchmark that
proves this, but in the meantime use these rules:
1. If the existing rows and anticipated rows never go beyond N characters,
make the column N + some.
2. If you cannot predict how much text will be entered, use a text column
rather than varchar.
3. If you plan on indexing this column (i.e. other than a full-text index),
use char.
Arthur
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: August 29, 2005 1:01 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Field Sizes

On that note, is it good advice to make all text fields VarCHar in SQL
Server?