Microsoft SQL Server 2000: A Guide to Enhancements and New Features

Front Cover
Addison-Wesley Professional, 2002 - Computers - 557 pages
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

User Review - Flag as inappropriate

by akhilesh jain tulshi Ict Solutions

User Review - Flag as inappropriate

Very Important

Contents

SharmaCH01qxdpdf
1
SharmaCH02qxdpdf
33
SharmaCH03qxdpdf
49
SharmaCH04qxdpdf
77
SharmaCH05qxdpdf
99
SharmaCH06qxdpdf
113
SharmaCH07qxdpdf
145
SharmaCH08qxdpdf
155
SharmaCH17qxdpdf
235
SharmaCH18qxdpdf
239
SharmaCH19qxdpdf
245
SharmaCH20qxdpdf
273
SharmaCH21qxdpdf
283
SharmaCH22qxdpdf
293
SharmaCH23qxdpdf
313
SharmaCH24qxdpdf
351

SharmaCH09qxdpdf
161
SharmaCH10qxdpdf
169
SharmaCH11qxdpdf
181
SharmaCH12qxdpdf
191
SharmaCH13qxdpdf
199
SharmaCH14qxdpdf
205
SharmaCH15qxdpdf
213
SharmaCH16qxdpdf
221
SharmaCH25qxdpdf
369
SharmaCH26qxdpdf
387
SharmaCH27qxdpdf
457
SharmaCH28qxdpdf
517
SharmaCHAqxdpdf
527
SharmaCHIqxdpdf
531
Copyright

Common terms and phrases

About the author (2002)

Rahul Sharma is a senior database administrator for Manhattan Associates, Inc., and a columnist for both Swynk.com and SQLServerCentral.com. He has been working with Microsoft SQL Server since the release of SQL Server 6.5 and is currently working with both SQL Server 2000 and Oracle 9i. He is a Microsoft Certified Professional with more than six years of experience in database administration.



0201752832AB11162001

Bibliographic information