"Call on Admin911 to learn what's going on with your network, to understand your options, and pick the right solutions." --David Chernicoff, Windows 2000 Magazine This survival guide for SQL Server 2000 administrators explains how to implement preventive problem-solving strategies and minimize downtime. Helpful call-outs throughout the book include: Take Command--Specific command-line utilities relating to the topic at hand Code Blue--Things to do when your system is in trouble Bug Alert--Common and little-know problems and pitfalls This book will also help you: *Manage SQL Server, including memory and security *Optimize and automate administration using SQL Server Agent and other tools *Debug Jobs *Monitor and tune SQL Server unsing the system monitor and alerts *Optimize T-SQL and stored procedures *Scale SQL Server using linked servers and Distributed Partitioned Views *Troubleshoot database performance *Implement disaster recovery procedures.