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!

Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: