With the exception
of database size, the values in this table apply equally to Microsoft SQL Server 2005 Express
Edition. The maximum size of a SQL Server 2005 Express database is 4GB.
The maximum size of data managed by SQL Server 2005 is practically unlimited because of SQL
Server??™s ability to be configured as clustered database servers.
TABLE A-9
Microsoft SQL Sever 2005 Capacities
SQL Server 2005 Database Engine Object Maximum Sizes/Numbers Maximum Sizes/Numbers
for SQL Server 2005 (32-bit) for SQL Server 2005 (64-bit)
Batch size 65,536 ?— Network Packet Size 65,536 ?— Network Packet Size
Bytes per short string column 8,000 8,000
Bytes per GROUP BY, ORDER BY 8,060 8,060
Bytes per index key 900 900
Bytes per foreign key 900 900
Bytes per primary key 900 900
Bytes per row 8,060 8,060
Bytes in source text of a stored Lesser of batch size or 250MB Lesser of batch size or 250MB
procedure
Bytes per varchar(max), 1,073,741,823 1,073,741,823
varbinary(max), xml, text,
or image column
1272
Appendixes Part VI
SQL Server 2005 Database Engine Object Maximum Sizes/Numbers Maximum Sizes/Numbers
for SQL Server 2005 (32-bit) for SQL Server 2005 (64-bit)
Characters per ntext or 536,870,910 536,870,910
nvarchar(max) column
Clustered indexes per table 1 1
Columns in GROUP BY, ORDER BY Limited only by number Limited only by number
of bytes of bytes
Columns or expressions in a GROUP 10 10
BY WITH CUBE or WITH ROLLUP
statement
Columns per index key 16 16
Columns per foreign key 16 16
Columns per primary key 16 16
Columns per base table 1,024 1,024
Columns per SELECT statement 4,096 4,096
Columns per INSERT statement 1,024 1,024
Connections per client Maximum value of Maximum value of
configured connections configured connections
Database size 1,048,516TB 1,048,516TB
Databases per instance of SQL Server 32,767 32,767
File groups per database 32,767 32,767
Files per database 32,767 32,767
File size (data) 16TB 16TB
File size (log) 2TB 2TB
Foreign key table references per table 253 253
Identifier length (in characters) 128 128
Instances per computer 16 16
Length of a string containing SQL 65,536 ?— Network packet size 65,536 ?— Network packet size
statements (batch size)
Locks per connection Maximum locks per server Maximum locks per server
Locks per instance of SQL Server Up to 2,147,483,647 Limited only by memory
Nested stored procedure levels 32 32
Nested subqueries 32 32
Nested trigger levels 32 32
continued
1273
Access 2007 Specifications A
TABLE A-9 (continued)
SQL Server 2005 Database Engine Object Maximum Sizes/Numbers Maximum Sizes/Numbers
for SQL Server 2005 (32-bit) for SQL Server 2005 (64-bit)
Nonclustered indexes per table 249 249
Parameters per stored procedure 2,100 2,100
Parameters per user-defined function 2,100 2,100
REFERENCES per table 253 253
Rows per table Limited by available storage Limited by available storage
Tables per database Limited by number of Limited by number of
objects in a database objects in a database
Partitions per partitioned table or index 1,000 1,000
Statistics on nonindexed columns 2,000 2,000
Tables per SELECT statement 256 256
Triggers per table Limited by number of Limited by number of
objects in a database objects in a database
UNIQUE indexes or constraints 249 nonclustered and 249 nonclustered and
per table 1 clustered 1 clustered
User connections 32,767 32,767
XML indexes 249 249
1274
Appendixes Part VI
This appendix provides you with information on the contents of the
CD that accompanies this book.
Pages:
2298
2299
2300
2301
2302
2303
2304
2305
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322