Microsoft SQL Server 2000: A Guide to Enhancements and New Features
Publisher: Pearson Education (March 19, 2002)
Format: PDF / Kindle / ePub
Size: 7.1 MB
Downloadable formats: PDF
This is a focused guide to SQL Server 2000 for experienced SQL Server administrators and developers. Rahul Sharma focuses on helping professionals take advantage of the powerful new features built into SQL Server 2000 -- and on providing real-world solutions, scripts, and utilities that can dramatically improve your effectiveness. Sharma begins with an overview of SQL Server 2000 focused on its compelling new features for both OLTP and OLAP applications. He reviews major enhancements to SQL Server 2000, including XML support, tight Web integration, indexed views, distributed partitioned views, user-defined functions, and more. Next, he moves on to advanced SQL Server 2000 database administration, including the use of SQL-DMO object models, database consistency checks, optimization techniques, and the latest bug fixes. The book includes a detailed comparison with Oracle 9i, as well as specific guidance for database professionals migrating to SQL Server or planning to use both databases in tandem. An extensive library of powerful scripts and utilities for SQL Server administration is presented in the book and on the accompanying CD-ROM. Sharma concludes with a preview of SQL Server.N ET, and the evolving role of databases in the .NET era. For all SQL Server database administrators, developers, and managers, and for others who depend upon SQL Server databases, including Web and e-Business professionals.