Microsoft® SQL Server® 2008 Bible

Appendix A. SQL Server 2008 Specifications

IN THIS APPENDIX

• Comparison of SQL Server specifications for versions 6.5 through 2008

Table A-1 provides a thorough and complete listing of all the different versions of SQL Server specifications.

Table A.1. SQL Server Specifications

Feature	6.5	7.0	2000	2005	2008
Server Features
Automatic Configuration	No	Yes	Yes	Yes	Yes
Page Size	2 KB	8 KB	8 KB	8 KB + extendable	8 KB + extendable
Max Row Size	1,962 bytes	8,060 bytes	8,060 bytes	8,060 bytes extendable based on data types	8,060 bytes extendable based on data types
Page-Level Locking	Yes	Yes	Yes	Yes	Yes
Row-Level Locking	Insert only	Yes	Yes	Yes	Yes
Files Located	Devices	Files and filegroups	Files and filegroups	Files and filegroups	Files and filegroups
Kerberos and Security Delegation	No	No	Yes	Yes	Yes
C2 Security Certification	No	No	Yes	Yes	Yes
Common Criteria Certification	No	No	No	Yes	Yes
Bytes per Character Column	255	8,000	8,000	8,000	8,000
Automatic Log Shipping	No	No	Yes	Yes	Yes
Persisted Computed Column	No	No	No	Yes	Yes
Max Batch Size	128 KB	65,536 * network packet–size bytes	65,536 * network packet–size bytes	65,536 * network packet–size bytes	65,536 * network packet–size bytes
Bytes per Text/Image	2 GB	2 GB	2 GB	2 GB	2 f
Bytes per VarChar(max)	–	–	–	2 GB	2 GB
Objects in Database	2 billion	2,147,483,647	2,147,483,647	2,147,483,647	2,147,483,647
Parameters per Stored Procedure	255	1,024	1,024	1,024	2,100
References per Table	31	253	253	253	253
Rows per Table	Limited by available storage	Limited by available storage	Limited by available storage	Limited by available storage	Limited by available storage ...