SQL Server 2005:13 Things you should know

It has been nearly a year since the launch of Microsoft's SQL Server 2005 Official edition. With the release of the last two studies, SQL Server 2005 has attracted the industry's attention and comments-Microsoft's SQL Server 2005 has achieved more than Oracle and IBM database product market share growth. However, for SQL Server 2005, which is less than one year old, there are a few things you should know about, and there are 13 things you should know about SQL Server 2005 in this article.

New features of SQL Server 2005

1. New Product Version

In addition to the SQL Server 2005 Standard Edition and Enterprise Edition, the product line also has a new version of SQL Server 2005 simplified (SQL Server Express) and Workgroup Edition (SQL Server Workgroup) two.

SQL Server express--is a replacement for the Microsoft SQL Server Desktop Engine (Microsoft SQL Server Desktop engine,msde). SQL Server Express can be used for free publishing and uses the same relational database core engine as SQL Server. The difference is that it does not use the query manager like MSDE. The only limit is a cpu,1g memory and 4G of storage space per database.

The SQL Server 2005--Workgroup Edition is not freely released. It is designed to focus on Server Message Block Protocol (SMB) and divisional solutions. It is better than SQL Server Express in quantitative performance and provides support for relational databases, but lacks analysis services. Workgroup Edition limited to two cpu,3g memory, database size unlimited.

2. The new subsystem

With the help of some new subsystems, application support in SQL Server 2005 is very powerful, including consolidation services, reminder services, service agents, and Reporting Services.

Consolidation services-600% faster than DTS, which was previously responsible for this functionality. SQL Server Consolidation Services is an enterprise-class ETL platform with powerful workflow control capabilities.

Reminder Service-Provides an application framework to build custom reminders.