Re: SQL Humor

From: JT <someone_at_microsoft.com>
Date: Fri, 19 Aug 2005 10:49:59 -0400
Message-ID: <uKelj2MpFHA.1416_at_TK2MSFTNGP09.phx.gbl>

Perhaps I'm misreading your point, but it's data in a Char column that typically contains trailing blanks that need a Trim. A VarChar won't contain extraneous blanks unless the developer explicitly includes them in the value.

"-CELKO-" <jcelko212_at_earthlink.net> wrote in message news:1124403285.842828.168210_at_g43g2000cwa.googlegroups.com...
>>> Any benchmark demonstrating that the performance degradation is not in
>>> single percentage digits is welcome. <<
>
> I am more worried about various numbers of extra blanks in the
> VARCHAR(n) making display problems. Trimming and padding are costly.
>
Received on Fri Aug 19 2005 - 16:49:59 CEST

This message: [ Message body ]
Next message: JT: "Re: SQL Humor"
Previous message: JT: "Re: SQL Humor"
Maybe in reply to: Mikito Harakiri: "Re: SQL Humor"
In reply to -CELKO-: "Re: SQL Humor"
Next in thread: -CELKO-: "Re: SQL Humor"
Reply: -CELKO-: "Re: SQL Humor"
Reply: Hugo Kornelis: "Re: SQL Humor"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message