Inside Microsoft Sql Server 2005

Inside Microsoft Sql Server 2005

by Kalen Delaney
     
 

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

See more details below

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 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.

Product Details

ISBN-13:
9780735621053
Publisher:
Microsoft Press
Publication date:
10/18/2006
Series:
Solid Quality Learning Ser.
Edition description:
2005 ed.
Pages:
466
Product dimensions:
7.30(w) x 9.00(h) x 1.10(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >