Microsoft SQL Server 2008 Editions

List of different versions and editions of SQL Server

•  Core Editions
• Standard
• For Small to Large businesses
• Can Use Max 4 CPUs
• Can Use Max OS RAM
• Enterprise
• For Enterprice Workload and BI.
• CPUs and RAM limited only by OS.
• Specialized Editions
• Workgroup
• Offices which need local instance.
• Can use Max 2 CPUs.
• Limited to use Max 4 GB of RAM.
• Web
• For Web Application Hosting.
• Can Use Max 4 CPUs
• Can Use Max OS RAM
• Developer
• It is an enterprise edition, Licenced for only development and testing.
• CPUs and RAM limited only by OS.
• Free Editions
• Express
• Entry level SQL Edition
• Can Use Max 1 CPUs
• Can Use Max 1 GB of RAM
• Database size is limited to 4GB.
• Compact 3.5
• For mobile or applications with embaded Database.
• CPUs and RAM limited only by OS.