O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required