Microsoft SQL Server 2000 Bible

Author: Nielsen
Publisher:
Publish Date: 2004-03-01
Features: As long as SQL Server 2000 can do it, you can too. This book comprehensively introduces the various knowledge required to utilize SQL Server 2000, Microsoft's high-performance, Web-enabled client/server database and data analysis software package. In this book, database expert Paul Nielsen, with a focus on performance and data integrity, demonstrates to users how to begin performance design from the very start of a database project. From basic installation operations to using XML, monitoring databases, and performance tuning (a very popular topic in itself, worthy of an entire book to discuss), Paul Nielsen provides clear operational instructions, ample and detailed theoretical knowledge, and effective methods for completing given tasks—"best practices." This book is not just an ordinary guide; it provides all the knowledge and methods needed to develop and use SQL Server. This book covers all the knowledge related to SQL Server development.
Master the methods of database schema design to improve the performance, integrity, and flexibility of database systems.
Understand ACID, transaction integrity, and create robust database systems.
Understand relational algebra to write powerful queries.
Optimize indexes to serve as bridges between data and queries.
Analyze query execution plans to improve performance.
Create T-SQL stored procedures, triggers, and user-defined functions.
Share data using DTS, distributed queries, XML, and ADO.NET.
Analyze data using Analysis Services.
Enable advanced scalability, availability, performance, and portability in database systems.