Microsoft SQL Server 2000: A Guide to Enhancements and New Features
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.NET, 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.
What people are saying - Write a review
Analysis Services application C H A P T E R characters CHECK constraints clause client clustered index code page collation command configuration connection constraints copy cube data columns data type DBCC default defined DELETE Desktop Engine dialog box disk DTS packages error example EXEC execution feature fetch foreign key indexed views INSERT install instance of SQL linked server locks login member tables Meta Data Services Microsoft SQL Server MSDE multiple NULL ODBC OLE DB OPENXML operations option parameter primary key provides query optimizer recovery model replication result set rows rowset schema script SELECT statement service pack setup specified spid SQL Server 2000 SQL Server 7.0 storage stored procedure syntax T-SQL T-SQL code table_name tasks template tion trace TraceID Transact-SQL transaction log trigger Unicode UPDATE upgrade user-defined functions XML document