SQL Server Performance

number of column for one table?

Discussion in 'Performance Tuning for DBAs' started by dba_boston, Jun 10, 2008.

  1. dba_boston Member

    Is there a limitation for number of column in one table?
    Micosoft documentation say it is 1024 for one table.
    We have a table have about 234 column right now, we recently add additional 9 columns, and we have noticed there is some performamce issue after the new coulmns have been added in.
    Is there any limitation for the page space for the column data/table?
    Thanks.
    dba_boston, Jun 10, 2008
    #2

  2. Luis Martin Moderator

    You are far away from 1024.
    So, did you full update statistics after new columns?
    Luis Martin, Jun 10, 2008
    #3

  3. MohammedU New Member

    MohammedU, Jun 11, 2008
    #4

Share This Page