SQL Server 2000: A Beginner's Guide

Your one-stop solution for getting up and running with SQL Server 2000Develop and deploy large-scale applications with SQL Server 2000. In this book, database expert Dusan Petkovic explains how to use all the features of this powerful, scaleable relational database management system. You'll learn to configure SQL Server 2000, use T-SQL, execute efficient database queries, and enable secure transactions. Troubleshooting, data warehousing, and optimization are also covered. You'll find complete details on Microsoft Analysis Services, managing multiple servers, maximizing uptime, and performance tuning. With SQL Server 2000: A Beginner's Guide, your mission-critical database applications will be up-and-running in no time!Learn to:• Setup, manage, and customize SQL Server 2000• Administer multiple instances of SQL Server 2000 using the SQL Server Enterprise Manager• Perform simple and complex database queries• Tune the performance of your SELECT statements• Use SQL extensions, stored procedures, transactions, views, and triggers• Implement the SQL Server 2000 security model• Find and fix database problems by capturing and replaying server activity• Import, export, and transform data types using DTS• Construct data warehouses to collect, organize, and distribute information efficiently