Re: SQL Humor

From: jxstern <jxstern_at_nowhere.xyz>
Date: Thu, 18 Aug 2005 14:52:55 -0700
Message-ID: <em0ag1p2v0mcc3726f5pbleoevcmfbf3qb@4ax.com>

On 18 Aug 2005 11:23:34 -0700, "Razvan Socol" <rsocol_at_gmail.com> wrote:
>> there is not a single advantage of char over varchar2
>
>"varchar2" ? You seem to live in an Oracle world, but here we are MS
>SQL Server people. And in SQL Server there is an advantage for char
>over varchar: char(n) has takes two bytes less to store than
>varchar(n), if the string has always n characters.

I've had my ear bent about some more putative performance advantages to char() fields, in that SQLServer can find the n'th data field more efficiently, so that you should put the char() fields to the front of the record and the varchar()'s to the end.

No idea if it's true or significant. Hope it's not too significant, since I've never actually paid any attention to it!

J. Received on Thu Aug 18 2005 - 16:52:55 CDT