Stored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation; data-handling operations of any complexity make use of them. This book is an in-depth guide to a key area of database development.This book tackles real-world problems faced by developers when working with stored procedures, showing how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularityanyone, not just database administrators, can use a SQL Server database.

This book recognizes that aspiring DBAs need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. Aspiring DBAs can benefit from the direction and advice of an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective DBA. In essence, this book is that "mentor," which is what sets it apart from the other books on the market that only present feature overviews.

Database novices will learn the core job and roles involved in administering a SQL Server database. You'll follow the life cycle of the database from installation, design, and modeling; through to development, tuning, and securing; and on to growth and migration. This comprehensive guide provides practical advice, answers typical questions that you'll encounter from managers and developers, and offers practical steps to overcome issues with which new DBAs traditionally struggle.

At every stage of the life cycle, this book supplies a range of tried-and-tested practices and techniques that will help you to establish and maintain a healthy database system.