Database Reference
In-Depth Information
•
Unlimited database size
•
Notification services
SQL Server Enterprise Edition:
Enterprise Edition (64-bit) provides the most
scalable data platform. Addressing more memory than any other edition of SQL Server,
it scales to the performance levels required to support the largest data warehousing and
analysis applications, ecommerce websites and enterprise business systems. This edition
runs on various Windows platforms ranging from Microsoft Windows 2003 Server with
Service Pack (SP) 2 or later to Windows Server 2008. This edition includes the full range of
features in the SQL Server suite. Among the prominent features are the following:
•
Support of 50 multiple instances
•
No limit on concurrent processors
•
RAM of 512 GB, or based on the underlying operating system
•
Compliant with 64 bit architecture
•
Unlimited database size
•
Table and index partitioning
•
Indexed views
•
Parallel index operations
•
Database snapshots
•
Integration services
•
Notification services
SQL Server Workgroup Edition:
The Workgroup Edition is the data management
solution for small organizations or workgroups within larger entities. It includes the entire
core database features needed for data management in an affordable and simple-to-manage
package. The platform requirements are similar to that of the Enterprise Edition. Among
the prominent features are the following:
•
Support of 50 multiple instances
•
Can support 2 concurrent processors
•
RAM of 3 GB
•
Unlimited database size
SQL Server Express Edition:
The Express Edition helps developers to use a
lightweight version of the product to build robust and reliable applications. The product
is free and can be downloaded from the Microsoft Web site. Among the prominent
features are the following:
•
Support for 1 processor only
•
RAM of 1 GB
•
Database size of 4 GB