SQL Server™ 2005 Bible

Appendix A. SQL Server 2005 Specifications

In This Appendix

• SQL Server specifications

• Comparison of SQL Server specifications for versions 6.5 through 2005

Table A-1, starting on the following page, lists the SQL server specifications for SQL Server 2005. Table A-2, which follows, lists its edition features.

Table A-1. SQL Server Specifications

Feature	SQL Server 6.5	SQL Server 7.0	SQL Server 2000	SQL Server 2000
Server Features
Automatic Configuration	No	Yes	Yes	Yes
Page Size	2KB	8KB	8KB	8KB + extendable
Max Row Size	1,962 bytes	8,060 bytes	8,060 bytes	8,060 bytes
Page-Level Locking	Yes	Yes	Yes	Yes
Row-Level Locking	Insert only	Yes	Yes	Yes
Files Located	Devices	Files and filegroups	Files and filegroups	Files and filegroups
Kerberos and Security Delegation	No	No	Yes	Yes
C2 Security Certification	No	No	Yes	Yes
Bytes Per Character Column	255	8,000	8,000	8,000
Automatic Log Shipping	No	No	Yes	Yes
Index-Computed Column	No	No	Yes	Yes
Max Batch Size	128KB	65,536 * network packet–size bytes	65,536 * network packet–size bytes	65,536 * network packet–size bytes
Bytes Per Text/Image	2GB	2GB	2GB	2GB
Objects in Database	2 billion	2,147,483,647	2,147,483,647	2,147,483,647
Parameters Per Stored Procedure	255	1,024	1,024	1,024
References Per Table	31	253	253	253
Rows Per Table	Limited by available storage	Limited by available storage	Limited by available storage	Limited by available storage
Table Per Database	2 billion	Limited by available storage	Limited by available storage	Limited by available storage
Table Per select Statement	16	256	256	256
Triggers Per Table	3	Limited by number of objects ...