Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.
Discover how to:
Upgrade or migrate to SQL Server 2005 and choose configuration options Control space allocation for databases and files manually or automatically Manage transaction logs to maximize efficient restore operations and data consistency Observe the internal structures of clustered and nonclustered indexes Build and partition relational indexes and tables Explore internal storage issues and compare fixed- and variable-length datatypes Detect and correct index fragmentation Implement and manage an appropriate concurrency model using locking or row versioning
PLUS—Get code samples on the Web.
Foreword;
Acknowledgments;
Introduction;
A History of Inside Microsoft SQL Server;
Series Structure;
Examples and Scripts;
Topics Not Covered;
Caveats and Disclaimers;
How to Get Support;
Chapter 1: Installing and Upgrading to SQL Server 2005;
SQL Server 2005 Prerequisites;
Pre-Installation Decisions;
Getting Ready to Install;
To Migrate or Upgrade?;
Selecting Components;
Summary;
Chapter 2: SQL Server 2005 Architecture;
Components of the SQL Server Engine;
Memory;
Final Words;
Chapter 3: SQL Server 2005 Configuration;
Using SQL Server Configuration Manager;
System Configuration;
Final Words;
Chapter 4: Databases and Database Files;
System Databases;
Sample Databases;
Database Files;
Creating a Database;
Expanding or Shrinking a Database;
Using Database Filegroups;
Altering a Database;
Databases Under the Hood;
Setting Database Options;
Database Snapshots;
The tempdb Database;
Database Security;
Moving or Copying a Database;
Compatibility Levels;
Summary;
Chapter 5: Logging and Recovery;
Transaction Log Basics;
Changes in Log Size;
Reading the Log;
Backing Up and Restoring a Database;
Summary;
Chapter 6: Tables;
System Objects;
Creating Tables;
User-Defined Data Types;
IDENTITY Property;
Internal Storage;
Constraints;
Altering a Table;
Summary;
Chapter 7: Index Internals and Management;
Index Organization;
Creating an Index;
The Structure of Index Pages;
Index Space Requirements;
Special Indexes;
Table and Index Partitioning;
Data Modification Internals;
Managing Indexes;
Using Indexes;
Summary;
Chapter 8: Locking and Concurrency;
Concurrency Models;
Transaction Processing;
Locking;
Lock Compatibility;
Internal Locking Architecture;
Bound Connections;
Row-Level Locking vs. Page-Level Locking;
Row Versioning;
Other Features That Use Row Versioning;
Controlling Locking;
Summary;
Appendix : About the Author;
Appendix : Additional Resources for Developers;
Visual Basic 2005;
Visual C# 2005;
Web Development;
Data Access;
SQL Server 2005;
Other Visual Studio 2005 Topics;
Other Developer Topics;
Appendix : More Great Developer Resources;
Developer Step by Step;
Developer Reference;
Advanced Topics;
Anonymous
Posted Wed Nov 08 00:00:00 EST 2006
Like it's predecessors this book is a must buy for any SQL Server DBA or Developer who requires more than a basic knowledge of the way the database storage engine works. A very well written book that is very readable, it contains information that can¿t be found in any other book.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Mon Feb 07 00:00:00 EST 2011
No text was provided for this review.
Overview
Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.
Discover how to:
Upgrade or migrate to SQL Server 2005 and choose configuration options Control space allocation for databases and ...