Post reply

What is limit of colums in SQl server 2005? and size limit of one cell or column?

  • January 21, 2008 at 10:09 pm

    #119698

    Hi,

    I want to know

    How many colums can SQl server 2005 have? and size limit of one cell or column?

  • January 21, 2008 at 11:29 pm

    #770348

    Columns per base table 1,024

    Bytes per short string column 8,000

    Bytes per row8 8,060

  • January 22, 2008 at 5:07 am

    #770425

    I haven't tried to find the information in 2k5, but you really need to be careful... although the max number of columns may be 1024 per table, you need to check out the replication limits... in 2k, they were much lower.

    Also, if you have a table that isn't the result of a flat file import that's hundreds of columns wide, you're probably doing something horribly wrong in the design of the table.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 22, 2008 at 6:51 am

    #770446

    Correct - it's 1000 with SQL Server snapshot/transactional replication, 995 with Oracle snapshot replication, and 246 in a Merge Replication process.

    http://msdn2.microsoft.com/en-us/library/ms143432.aspx

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply