Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Char vs Varchar - Performance
Message
From
01/02/2005 11:06:59
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00982531
Message ID:
00982678
Views:
36
>Yes, in SQL 2000 fixed lenght data types always take the same space regardless what value is stored in it.<

Another good reason to use varchars!!! <g>

Thanks, Sergey.

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform