Performance Centric Database Design: Applying advanced designs to prevent bottlenecks

This book is about preventing performance problems before they occur. The author shows ways how to apply common sense to database design at the example of SQL Server 2008 as a relational database management system. Prevention and design strategies are discussed to create scalable, manageable and elegant foundations for any application, no matter how small they start and how large they grow - from the basics such as choosing the right data type to archiving and accessing historic data.