SQL Server 2000 Practical Complete Collection

Author: Lan
Publisher:
Publish Date: 2002-09-01
Features: "SQL Server 2000 Practical Handbook" stands out for its highly practical advice and in-depth explanations. With our comprehensive guidance, you will gain the necessary skills to fully and thoroughly understand the knowledge you acquire and leverage it to unlock the full potential of SQL Server 2000. The book introduces how to:
- Effectively perform installation and upgrades
- Use effective backup and recovery techniques to minimize data loss
- Manage transactions and distributed transactions
- Employ effective design, optimization, and tuning techniques to ensure database performance
- Generate and manage objects such as views, stored procedures, and triggers
- Use BCP and DTS for data import and export
- Integrate SQLMail to extend SQL Server functionality
"SQL Server 2000 Practical Handbook" provides an in-depth exploration of Microsoft SQL Server 2000 knowledge and offers numerous practical tips, making it a bible for database administrators and developers. The book focuses on introducing SQL Server 2000's core database products and daily management and maintenance tasks, while also providing a detailed and thorough explanation of SQL Server 2000's new features. It covers how to effectively perform installation and upgrades, use effective backup and recovery techniques to minimize data loss, and comprehensively explains transaction and distributed transaction management, as well as how to ensure database performance through effective design, optimization, and tuning techniques. Additionally, it guides you on generating and managing objects such as views, stored procedures, and triggers, using BCP and DTS for data import and export, and integrating SQLMail to extend SQL Server functionality.
The book also includes topics such as using new tools, coding Transact-SQL, server management, query analysis and optimization, data warehousing, managing ultra-large databases, and performance tuning. Compared to similar books, this one offers a broad scope, up-to-date content, moderate depth of explanation, and numerous typical examples. With this book, SQL Server administrators and developers can better understand the SQL Server product. Especially for readers responsible for analyzing, designing, implementing, supporting, managing, or troubleshooting SQL Server 2000, this book provides an exceptionally rich resource. Therefore, it is an excellent reference for intermediate to advanced readers.