Books are great references, and can be an effective learning tool.
Memorize me, and you shall have power unlimited!
Memorize me, and you shall have power unlimited!
The Reference Set
These books are canon for SQL Server developers and administrators.
Microsoft SQL Server 2008: T-SQL Fundamentals
Microsoft SQL Server 2008: Internals
Microsoft SQL Server 2008: T-SQL Programming
Microsoft SQL Server 2008: T-SQL Querying
Performance Tuning
These are the three best books I’ve found for performance tuning.
SQL has a Turbo button!
Professional SQL Server 2008 Internals and Troubleshooting
SQL Server 2008 Query Performance Tuning Distilled
Database Design
These are the books I always use when doing development or architecture work.
Careful design is for wimps. What could go wrong?
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
Pro SQL Server 2008: Relational Database Design and Implementation
