Buy this book with Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning) by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning) today!

Buy Together Today: £43.93

Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning) by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning)  (2)  £20.14

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning)  (9)  £20.14

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney  (1)  £22.09

Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft)) by Reed Jacobson; Stacia Misner; Hitachi Consulting  (2)  £18.19

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft® SQL Server™ 2005—Implementation and Maintenance: Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) by Solid Quality Learning  (4)  £26.64

› Explore similar items : Books (49) Software (1)

Product Description
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 

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

See all Product Description

Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index

Search inside this book: