Inside Microsoft SQL Server(TM) 2005: The Storage Engine (Solid Quality Learning)

Kalen Delaney

ISBN 10: 0735621055 / ISBN 13: 9780735621053

Published by Microsoft Press, 2006

About this Item

Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages.

Seller Inventory # M00735621055-V

Bibliographic Details

• Title: Inside Microsoft SQL Server(TM) 2005: The Storage Engine (Solid Quality Learning)
• Publisher: Microsoft Press
• Publication Date: 2006
• Language: English
• ISBN 10: 0735621055
• ISBN 13: 9780735621053
• Binding: Soft cover
• Condition: very good

About this title

Synopsis

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.

About the Authors

Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.

Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.