Limitations on Table Size and Dimensions

You are limited to what you can store in a SQL Server 2000 table, but it is unlikely that you will ever reach this limit. If you are approaching the size limitations for a table, you should consider partitioning the data either vertically (split the columns into multiple tables) or horizontally (split the rows among multiple tables).

The number of columns in a table is limited to 1,024. The amount of bytes in a row is limited to 8060KB; however, datatypes such as images can store up to 2GB because the data is stored outside the data row on separate data pages. The number of rows in a table is limited only by the available storage; this is likely to be a physical limit and not a database limit. SQL Server allows 32,767 files per database, with a maximum file size of 32 terabytes (TB). Don't bother doing the math; you don't have that much data. But hey, who knows what next year will bring. I remember when 20MB hard drives were all the rage!

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features