Microsoft SQL Server 6.5 Unleashed

This comprehensive reference details the steps needed to plan, design, install, administer, and tune large and small databases. In many cases, the reader will use the techniques in this reference to create and manage their own complex environment. Users of Microsoft SQL Server 6.5 Unleashed, Second Editon will learn to: write efficient SQL queries; master transaction management; design indexes for query optimization; learn remote server management; secure their server and network; replicate their database and manage it on various platforms; back up and restore their server; implement continuous database logs; learn ODBC Programmingp; administer very large databases; put their database on the World Wide Web; discover the Query Optimizer; explore the SQL Server Distributed Management Framework; and improve the efficiency and reliability of their databases with DBCC.

• CD-ROM includes source code, libraries, and administration tools