dcsimg

Table 1:

Object Maximum sizes/numbers
Database size 1 Gb
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 / 1 Gb

Table 2:

Object Maximum sizes/numbers
Batch size 65,536 * Network Packet Size
Bytes per short string column 8,000
Bytes per text, ntext,or image column 2 GB-2
Bytes per index 900
Bytes per foreign key 900
Bytes per primary key 900
Bytes per row 8,060
Bytes in source text of a stored procedure Lesser of batch size or 250 MB
Clustered indexes per table 1
Columns per index 16
Columns per foreign key 16
Columns per primary key 16
Columns per base table 1,024
Columns per SELECT statement 4,096
Columns per INSERT statement 1,024
Connections per client Maximum value of configured connections
Database size 1,048,516 TB
Databases per instance of SQL Server 32,767
Filegroups per database 256
Files per database 32,767
File size (data) 32 TB
Identifier length (in characters) 128
Locks per connection Max. locks per server
Nested stored procedure levels 32
Nested subqueries 32
Nested trigger levels 32
Nonclustered indexes per table 249
Objects in a database 2,147,483,6474
Parameters per stored procedure 1,024
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