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 FelipeI 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 table.next column for type , next column data For Ex: say you are you going to have your table
ID A B C D E F G
================
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
http://dineshasanka.spaces.live.com/
Based on info provided you may need to improve your design by normalizing the table.
]]>