In the old days, using varchar
over char
was a big no no, since the varchar
was stored on a different page than the rest of the row. Is this still the case today with SQL Server 2008? Will I see any memory/performance gain from changing 1-3 varchar(5)
columns to char(5)
columns on a table with
a) say 2.000.000 rows
b) if any of the varchar
columns are part of indexes / the primary keys