Databases (Access, SQL Server ...) SQL SERVER 2005

 Inside SQL Server 2005: The Storage Engine

Published by: MICROSOFT PRESS
Author: Delaney, Kalen
Group: SQL SERVER 2005
ISBN: 0735621055
ISBN 13: 9780735621053
Number of pages: 432
User level: Intermediate/Advance
Objective: Reference Date Published: Oct 2006
 RRP £39.49 Save 35%
 Online Price £25.66

 Book Information

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

ForewordAcknowledgmentsIntroductionChapter 1: Installing and Upgrading to SQL Server 2005Chapter 2: SQL Server 2005 ArchitectureChapter 3: SQL Server 2005 ConfigurationChapter 4: Databases and Database FilesChapter 5: Logging and RecoveryChapter 6: TablesChapter 7: Index Internals and ManagementChapter 8: Locking and ConcurrencyAppendix : About the AuthorAppendix : Additional Resources for DevelopersAppendix : More Great Developer Resources