SQL Server 2000 Improvement

Author: Wu Hao
Publisher:
Publish Date: 2005-06-01
Features: Building upon the foundation of "SQL Server 2000 Basics," this book further introduces advanced knowledge in database management and development for SQL Server 2000. It consists of 18 chapters and two appendices. The main content includes normalization design, SQL Server storage and indexing structures, transactions and locks, advanced queries, an introduction to XML, XML integration, full-text search, English queries, distributed queries and transactions, Data Transformation Services (DTS), advanced DTS, the bulk copy program (bcp), advanced design, Analysis Services, database security, performance testing, and an overview of management. Each knowledge point is combined with practical examples to demonstrate how to apply the knowledge. Additionally, the appendices provide system and operational functions for SQL Server 2000. This book is suitable for SQL Server database administrators and advanced developers, with a focus on developers. Combined with "SQL Server 2000 Basics," it also offers significant help for beginners seeking further improvement. The book primarily covers normalization design, SQL Server storage and indexing structures, transactions and locks, advanced queries, an introduction to XML, XML integration, full-text search, English queries, and distributed queries and transactions.