SQL Server 2005:13 Things you should know

Source: Internet
Author: User
Tags ibm database microsoft sql server sql new features sql server express

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.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.