Table B-1: SQL Server system specifications

System Specifications
Hardware
Processor	32-bit
RAM required for SQL Server	32MB
Minimum RAM per additional user	52K	With default stack size and packet size
Database Statistics
Databases per SQL Server	32,767	Note that practical limit is approximately 100
Default database size	2MB
Maximum database size	238 (256 gigabytes)
Minimum database size	Default (2MB)
Creation of clustered index	Free space needed in database is 1.1* (size of table) + 10%
Maximum size of a database device	2 (^ 31 ) (2GB)
Maximum number of database devices per server	255
Maximum number of devices or device pieces per database	128
Maximum number of segments per database	31
Maximum number of data bytes per text/image page	1800
Table Statistics
User objects per database	231 - 100
Columns per table	250
Indexes per table	250 (one clustered)
Rows per table	Limited by available storage
Maximum size of a row	1960 bytes
Columns per composite index	16
Bytes per index key	256
Characters per database object name	30
Query Statistics
Maximum number of databases participating in one transaction	16	Includes database where transaction began, all databases changed during transaction, and tempdb if it is used for results or work tables
Practical number of databases participating in one query	16 (dependent on available memory)	Includes each occurrence of each database queried, and tempdb if it is used for results or worktables
Maximum number of tables participating in a query	16	Includes all work tables, result tables, tables referenced by views (the view itself is not counted), correlations, and self-joins
Maximum number of where clauses referencing a table in a query	128
System Statistics
Number of buffers and procedure buffers	Configurable	Limited by amount of RAM and maximum size of shared memory segment
Minimum memory required per stored procedure	2K
Maximum number of parameters per stored procedure	255