Microsoft Access 2010 Bible

Part VII: Appendixes

1250

SQL Server 2008 Express Edition is a 32-bit application. It runs in a 32-bit process space when

run on 64-bit operating systems.

Table A.6 includes the specifications for SQL Server 2008 Express Edition only. The other SQL

Server 2008 editions are similar in most regards, with the exception of maximum database size.

Also, there are some differences in limits between the 32- and 64-bit versions of SQL Server 2008.

These variations make it difficult to include every limit for every edition of SQL Server 2008.

TABLE A.6

Microsoft SQL Sever Express Capacities

SQL Server Database Engine Object Maximum Size or Number for SQL Server 2008 Express

CPU core utilization 1 (SQL Server Express does not utilize more than one

CPU core on multi-core machines.)

Maximum memory utilization 1GB

Batch size 65,536 × network packet size

Bytes per short string column 8,000

Bytes per GROUP BY, ORDER BY 8,060

Bytes per index key 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 250MB

Bytes per varchar(max), varbinary(max),

xml, text, or image column

1,073,741,823

Characters per ntext or nvarchar(max)

column

536,870,910

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 key 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

49_475348-bapp01.indd 125049_475348-bapp01.indd 1250 4/1/10 2:01 PM4/1/10 2:01 PM