Flame,
Just found this article, it does a comparison between the performance of varchar and char fields... And pretty much concludes there's bugger all difference! Still, quite interesting!
http://sqljunkies.com/WebLog/odds_and_ends/archive/2005/09/12/16725.aspx
And speaking of performance there's not gain from using ^2 values in field sizes, but I still do it all the time!
Just found this article, it does a comparison between the performance of varchar and char fields... And pretty much concludes there's bugger all difference! Still, quite interesting!
http://sqljunkies.com/WebLog/odds_and_ends/archive/2005/09/12/16725.aspx
And speaking of performance there's not gain from using ^2 values in field sizes, but I still do it all the time!