Limit start size from columns | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Limit start size from columns

Good Evening, I want to create a table with 20 columns STRING(300). My question: How can I limited the % size from my columns when I create the database? Because 90% of my clients will use just 1 of the 20 columns that I create. Thanks Felipe
I think you need to change your design What if, you have another table which links to master table. new table will have three columns. One to link with master column for type , next column data For Ex: say you are you going to have your table
1 2
2 1
3 c for the above table you can have new table
ID Type Values
1 A 2
2 B 1
3 C c
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

Based on info provided you may need to improve your design by normalizing the table.