Foreword

It has been twenty years since relational database management systems began their transition from research projects and barely usable early product releases into today’s primary method of storing and accessing data in commercial applications. Tuning for those early systems consisted largely of choosing the amount of system resources to devote to them, allocating storage, and defining indexes. While this simplicity was often considered a strength, the inability to tune or optimize the application’s use of these systems limited their ability to be used in very demanding applications. Today’s SQL Server 2005 offers the best of both worlds, continuing to allow many applications to be written with little or no effort applied to tuning and ...

Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.