SQL Server can have as many as 2 billion tables per database and 250 columns
per table. The number of rows and total size of the table
are limited only by the available storage. The maximum size of a database is 1
terabyte (TB). A table can be as large as 1 TB minus the size
of the database catalog and any other objects. The maximum number of bytes per
row is 1962. If you create tables with varchar or varbinary
columns whose total defined width exceeds 1962 bytes, the table is created but
a warning message appears. Trying to insert more than
1962 bytes into such a row or to update a row so that its total row size
exceeds 1962, produces an error message and the statement failes.
For detailes on calculting row size, see the Microsoft SQL Server
Administrator's Companion.
