SQL Server Performance

Limit start size from columns

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by feliberal, Jan 18, 2007.

  1. feliberal New Member

    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

  2. dineshasanka Moderator

    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 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/
  3. mmarovic Active Member

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

Share This Page