Sams Teach Yourself Microsoft SQL Server 7 in 21 Days
by Richard Waymire, Rick Sawtell
Publisher: Sams 1998
Number of pages: 800
The book introduces you to every aspect of Microsoft's flagship back-end database engine. Organized with a FAQ-like summary at the end of every chapter, the book familiarizes you with all the features and even brings you up to expert level on a few of them. Waymire and Sawtell explain how to install the software under Windows NT Server 4. After a quick synopsis of the tools and utilities on the SQL Server CD-ROM, the authors walk you through the process of creating databases and establishing accounts for the people and processes that will access them.
Home page url
Download or read it online for free here:
by Grant Fritchey - Simple Talk Publishing
An execution plan describes what's going on behind the scenes when SQL Server executes a query. This book leads you right from the basics of capturing plans, through how to interrupt them, and how to diagnose the causes of poor query performance.
by Buck Woody - Pearson Education
Database professional Buck Woody leads you through the many aspects of designing, administering, and developing for your SQL Server platform. Recommended for DBAs and developers, this Reference Guide covers SQL Server 2000 up to SQL Server 2008 R2.
by Alex Kuznetsov - Red Gate Books
The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. In this book, you will find practical programming techniques that will improve the quality of your T-SQL code and increase its robustness.
by Holger Schmeling - Simple-Talk Publishing
Reading Holger's booklet is a great way of brushing up on the subject of Statistics and query-optimization. It is reasonably short, and geared to the practitioner rather than the theoretician. It is careful to stick with the things you need to know.