Maximum Capacity Specifications for SQL Server 2005

Batch size : -> 65,536 * Network Packet Size

Bytes per short string column : -> 8000

Bytes per text, ntext, image, varchar(max), nvarchar(max), varbinary(max), or XML column : -> 231 -1 bytes/p>

Bytes per GROUP BY, ORDER BY : -> 8060

Bytes per index : -> 900

Bytes per foreign key : -> 900

Bytes per primary key : -> 900

Bytes per row : -> 8060

Bytes in source text of a stored procedure : -> Lesser of batch size or 250 MB

Clustered indexes per table : -> 1

Columns in GROUP BY, ORDER BY : -> Limited only by number of bytes

Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement : -> 10

Columns per index : -> 16

Columns per foreign key : -> 16

Columns per primary key : -> 16

Columns per base table : -> 1024

Columns per SELECT statement : -> 4096

Columns per INSERT statement : -> 1024

Connections per client : -> Maximum value of configured connections

Database size : -> 1,048,516 terabytes

Databases per instance of SQL Server : -> 32767

Filegroups per database : -> 32767

Files per database : -> 32767

File size (data) : -> 32 terabytes

File size (log) : -> 32 terabytes

Foreign key table references per table : -> 253

Identifier length (in characters) : -> 128

Instances per computer : -> 50

Length of a string containing SQL statements (batch size) : -> 65,536 * Network packet size

Locks per connection : -> Maximum locks per server

Locks per instance of SQL Server : -> Up to 2,147,483,647

Nested stored procedure levels : -> 32

Nested subqueries : -> 32

Nested trigger levels : -> 32

Nonclustered indexes per table : -> 249

Objects concurrently open in an instance of SQL Server : -> 2,147,483,647 per database (depending on available memory)

Objects in a database : -> 2147483647

Parameters per stored procedure : -> 2100

Parameters per user-defined function : -> 2100

REFERENCES per table : -> 253

Rows per table : -> Limited by available storage

Tables per database : -> Limited by number of objects in a database

Tables per SELECT statement : -> 256

Triggers per table : -> Limited by number of objects in a database

UNIQUE indexes or constraints per table : -> 249 nonclustered and 1 clustered