Sams Teach Yourself Microsoft SQL Server 7 in 21 Days
by Richard Waymire, Rick Sawtell
Publisher: Sams 1998
Number of pages: 679
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.
Download or read it online for free here:
by Jonathan Kehayias, Ted Krueger - Red gate books
SQL Server-related performance problems come up regularly and diagnosing and solving them can be difficult and time consuming. Read this book for descriptions of the most common issues and practical solutions to fix them quickly and accurately.
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 Ross Mistry, Stacia Misner - Microsoft Press
This book is for anyone who has an interest in SQL Server 2008 R2 and wants to understand its capabilities. The purpose is to point out both the new and the improved in the latest version of SQL Server. Some familiarity with SQL Server is assumed.
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.