SQL server 2005 Editions

Author : Exforsys Inc. Published on: 23rd Nov 2005

SQL server 2005 Editions

The SQL Server 2005 family includes a number of editions—Express, Workgroup, Standard and Enterprise . Each of these editions comes with a range of features. These include high availability, Scalability to high business Intelligence tools—all aimed at empowering the organization and catering to mission critical information streaming down the levels in accordance with the security and authentication policies defined. The low cost mainstream database gives value and functionality and is a dramatic step forward in reducing application downtime. The following table indicates the scalability and performance parameters of the different editions.

Ads

Scalability and Performance

Feature	Express	Workgroup	Standard	Enterprise	Comments
Number of CPUs	1	2	4	No Limit	Includes support for multi-core processors.
RAM	1 gigabyte (GB)	3 GB	Operating system maximum	Operating system maximum	Memory limited to maximum supported by operating system.
64-bit Support	Windows on Windows (WOW)	WOW	Yes	Yes
Database Size	4 GB	No Limit	No Limit	No Limit
Partitioning				Yes	Support for large-scale databases
Parallel Index Operations				Yes	Parallel processing of indexing operations
Indexed Views				Yes	Indexed view creation is supported in all editions. Indexed view matching by the query processor is only supported in Enterprise Edition.

High Availability

Feature	Express	Workgroup	Standard	Enterprise	Comments
Database Mirroring¹			Yes²	Yes	Advanced high availability solution that includes fast failover and automatic client redirection
Failover Clustering			Yes³	Yes
Backup Log-shipping		Yes	Yes	Yes	Data backup and recovery solution
Online System Changes	Yes	Yes	Yes	Yes	Includes Hot Add Memory, dedicated administrative connection, and other online operations
Online Indexing				Yes
Online Restore				Yes
Fast Recovery			Read Next: SQL Server 2005 Installation This tutorial is part of a SQL Server 2005 Training tutorial series. Read it from the beginning and learn yourself. SQL Server 2005 Training SQL Server 2005 - Configuring Replication SQL Server 2005 Replication Enhancements SQL Server 2005 - Mirror Server SQL Server 2005 - Introduction to Data Availability SQL Server 2005 - Backing up a Database SQL Server 2005 - Using Database Snapshots SQL Server 2005 - Disaster Recovery SQL Server 2005 - Managing Certificates SQL Server 2005 - Managing Permissions Managing SQL Server 2005 Security SQL Server 2005 - Using the Database Tuning Advisor SQL Server 2005 - Tuning a Database Maintain indexes in a SQL Server 2005 database SQL Server 2005 - Defining Indexes SQL Server 2005 - Database Backup SQL Server 2005 - Populating the Database SQL Server 2005 Configuration Manager SQL Server 2005 - Using the Sqlcmd Utility Using the SQL Management Objects Using SQL Sever Management Studio - Part 2 Using SQL Sever Management Studio - Part 1 SQL Server 2005 - Using Event Notifications SQL Server 2005 - Using DDL Triggers SQL Server Monitoring Tools - Server Profiler SQL Server 2005 - Testing Troubleshooting SQL Server 2005 - Upgrading from earlier versions of SQL Server SQL Server 2005 Installation - Maintenance Plan Without Using Wizard SQL Server 2005 - Unattended Installations SQL Server 2005 Installation - Maintenance Plan Using Wizard Installing a Second Copy of SQL Server 2005 Planning to Install SQL Server 2005 SQL Server 2005 Installation SQL server 2005 Editions SQL Server 2005 Architecture Overview SQL Server 2005 - Management studio interface Summary Page SQL Server 2005 - Server Groups SQL Server 2005 - Registered Servers SQL Server 2005 Administrative Tools Developing Client applications in SQL Server 2005 SQL Server Management Objects NET CLR in SQL Server 2005 Native HTTP Support in SQL Server 2005 XML Data Types in SQL Server 2005 Using XML in SQL Server 2005 Using Notification Services in SQL Server 2005 SQL Server 2005 - Service Broker Data Manipulation Language (DML) in SQL Server 2005 T-SQL Enhancements in SQL Server 2005 Security Features in SQL Server 2005 for the Developer SQL Server Architecture and Components SQL Server 2005 Management Studio Overview of SQL Server 2005 for the Database Developer Getting started with SQL Server 2005 Comments Go Top Share Connect Related Articles Client Server Models in Business Environment Client-Server Models and N-Tier Applications Developing Client applications in SQL Server 2005 How To Create a Java Server Application How To Use Java DB as Your Client Mobile Database Pros and cons of client/server computing Client Server Features Client Server Architecture Client-Server Computing : Butler Model Client Server : Object Request Brokers Unix Client Server Technology .NET Client-Server Technology Client-Server Technology : Thin Clients Client-Server Security Client-Server Trends for 2007 Exforsys e-Newsletter Enhance Technical and Soft Skills every week, get our Job Interview Questions and Answers eBook free when you subscribe. Subscribe and Get Free Bonus PDF Book Privacy and Legal \| Contact Us \| DMCA \| Sitemap Copyright © 2000 - 2012 exforsys.com. All Rights Reserved