|
Q1: What are the different editions of SQL Server 2005?
1) SQL Server 2005 Express:
Fastest way for developers to learn, build, and deploy, data-drivien applications.
1 CPU, 1 GB RAM, 4 GB DB Size
Simple Management Tool.
Report Wizard and Report Controls.
Replication and SSB Client.
2) SQL Server 2005 Workgroup:
Easiest to use and most affordable database solution for smaller departments and growing businesses.
2 CPU, 3 GB RAM
Management Studio.
Import/Export.
Limited Replication Publishing.
Back-up Log-shipping.
3) SQL Server 2005 Standard:
Complete data management and analysis platform for medium businesses and large departments
4 CPU, Unlimited RAM (64-bit)
Database Mirroring.
OLAP Server.
Reporting Server.
New Integration Services.
Data Mining.
Full replication and SSB Publishing.
4) SQL Server 2005 Enterprise:
Fully integrated data management and analysis platform for business critical enterprise applications.
Unlimited Scale + Partitioning.
Advanced DB Mirroring, Complete Online and Parallel Operations.
DB Snapshot.
Advanced Analysis Tools including full OLAP and Data Mining.
Customized and High Scale Reporting.
Advanced SSIS.
|