Inside Microsoft® SQL Server™ 2005: The Storage Engine

Published:	October 11, 2006	Accompanying Media:	N/A
Author:	Kalen Delaney (Solid Quality Learning)	Language:	English
Length:	464 Pages	Level:	Intermediate, Advanced
ISBN 13:	9780735621053	Technology:	Microsoft SQL Server 2005
ISBN 10:	0-7356-2105-5	Format:	Paperback
List Price:	$ 49.99

About The BookGet expert architectural insights for building and maintaining robust databases.

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 Kalen Delaney (Solid Quality Learning)Kalen Delaney is also the Series Editor for the Inside SQL Server series of books from Microsoft Press. She has been working with SQL Server since 1987 and has been a Microsoft MVP since 1995. She is a founding mentor of Solid Quality Learning, where she helps develop courses and training materials. Kalen is a contributing editor and columnist for SQL Server Magazine and the author of several books on SQL Server, including Inside Microsoft SQL Server 2000.

Other Books By Kalen Delaney

Have Questions? For advice about training and certification, connect with peers:

Visit the training and certification forum

For questions about a specific certification, chat with a Microsoft Certified Professional (MCP):

Visit our MCP newsgroups

To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:

Visit the Microsoft Learning community

What do you think of this book?Your feedback is important in helping us create books that serve your needs and meet your expectations. Please take our survey at www.microsoft.com/learning/booksurvey

Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey. The ISBN 13 can be found above.
To report or search for corrections in this book or companion content,
please go to www.microsoft.com/learning/support/books/

Book index