Microsoft SQL Server
Microsoft SQL Server has engrained itself in corporate America. Microsoft SQL Server is a relational database server. Its primary query languages are T-SQL and ANSI SQL. It is available in all models.
SQL Server 2008 RS is the latest version and provides a secure, efficient, and smart data platform that enables businesses to run their most demanding mission-critical applications. Like Windows Server, there are many editions, each tailored to specific business sizes or technology requirements. The following table will help you select the appropriate edition:
| |
Core Editions
|
Specialized Editions
|
Free Editions
|
| |
Enterprise |
Standard |
Workgroup |
Web |
Developer |
Express |
Compact 3.5 |
|
Target Scenarios
|
Enterprise workloads that need redundancy and built-in Business Intelligence |
Shared data scenarios in departments and small to large businesses |
Remote offices that need local instances of company data |
For web application hosting |
Full featured edition for development and testing only |
Entry level database, ideal for learning and ISV redistribution |
Embedded database for developing desktop and mobile applications |
|
CPU
|
8 CPU |
4 CPU |
2 CPU |
4 CPU |
OS Maximum |
1 CPU |
OS Maximum |
|
Memory
|
2 TB Ram |
64 GB Ram |
4 GB |
OS Maximum |
OS Maximum |
1 GB |
OS Maximum |
|
DB Size
|
524PB |
524PB |
524PB |
524PB |
524PB |
10 GB |
4 GB |