Chapter 1 INTRODUCTION TO SQL SERVER 2000 15

Chapter 1 INTRODUCTION TO SQL SERVER 2000 15 Ease of installation, deployment, and use Data warehousing The SQL Server 2000 database engine includes integrated XML support. It also has features it needs to operate as the data storage component of the largest web sites. The SQL Server 2000 programming model is integrated with the Windows architecture for web application development, and SQL Server 2000 supports English Query and the Microsoft Search Service to allow for user-friendly queries and powerful search capabilities in web applications. The same database engine can be used across platforms ranging from laptop computers running Microsoft Windows 98 through multiprocessor servers running Microsoft Windows 2000 Data Center. SQL Server 2000 Enterprise Edition supports features such as federated servers, indexed views, and large memory support that enable it to scale to the performance levels required by the largest web sites. The SQL Server 2000 database engine supports features required by demanding environments. The database engine protects integrity while minimizing overhead. The engine is capable of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries enable you to reference data from multiple sources as if it were a part of a single SQL Server 2000 database. Distributed transaction support protects the integrity of any updates of the data dispersed on multiple sources. Replication enables you to maintain multiple copies of data, while also ensuring synchronization. SQL Server 2000 includes a complete set of administrative and development tools. SQL Server 2000 also supports a standards- based programming model, making the use of SQL Server databases and data warehouses a seamless part of building powerful systems. These features enable you to rapidly deliver SQL Server applications that can be implemented with a minimum of installation and administrative overhead. SQL Server 2000 includes tools for extracting and analyzing summary data for online analytical processing. SQL Server also includes tools for visually designing databases and analyzing data using English-based questions.

If you looking for unlimited one inclusive web hosting plan please check unlimited web hosting website.

Comments are closed.