Description:Complete. Authoritative. Practical. The only SQL Server book you need.Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. Coverage includes:Understanding SQL Server architectureDesigning an efficient normalized databaseWriting Transact-SQL statements and batchesCreating databasesCreating tables and viewsCreating stored procedures and triggersAdministering SQL ServerManaging SQL Server securityDesigning applications using ADO, SQL-DMO, and SQL-NSUsing Data Transformation ServicesIntegrating SQL Server with the InternetOptimizing SQL Server performanceUnderstanding and managing replicationUsing Analysis Services to analyze dataUsing Microsoft English QueryTroubleshooting common problems