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
|
| Author: http://venkattechnicalblog.blogspot.com/ 30 May 2008 | Member Level: Diamond Points : 2 |
Useful one Shiv shankar.
Regards,
Venkatesan Prabu . J
|
| Author: Mahesh Raj 07 Jun 2008 | Member Level: Gold Points : 1 |
This is very good information,Continue posting such useful articles.
|
| Author: sivakumar 08 Jun 2008 | Member Level: Silver Points : 0 |
Hi
This is useful one.
|