Choosing a version of SQL Server

By: Tibor Nagy

Overview

There are several different editions of Microsoft SQL Server and this may be a bit confusing for MySQL users. What are the main differences and which one should we choose?

Explanation

The editions of SQL Server 2008 are as follows:

• Enterprise: this is the high-end edition with the full feature set. It supports systems up to 8 CPU and 2 TB RAM. The maximum size of the database is 524 PB.
• Standard it has a bit less features than Enterprise, but it is a good choice when advanced functions (such as data compression, compressed backups, indexed views, etc.) are not required for the business. It supports systems up to 4 CPU and 64 GB RAM.
• Workgroup: it is suitable for remote offices of a larger company. It supports systems up to 2 CPU and 4 GB RAM.
• Web: it is designed for web applications. It supports 4 CPU without memory limitations.
• Developer: similar to Enterprise, but licensed to only one user for development, testing and demo. It can be easily upgraded to Enterprise without reinstallation.
• Express: free entry level database. It can utilize only 1 CPU and 1 GB memory, the maximum size of the database is 10 GB.
• Compact: free embedded database for mobile application development. The maximum size of the database is 4 GB.

Additional Information

• Comparison of SQL Server 2008 editions at Microsoft.com