Inside Microsoft Sql Server 2005

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

See more details below
Paperback (2005 ed.)
$37.70
BN.com price
(Save 24%)$49.99 List Price
Other sellers (Paperback)
  • All (27) from $1.99   
  • New (3) from $16.00   
  • Used (24) from $1.99   
Sending request ...

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.

Read More Show Less

Product Details

  • ISBN-13: 9780735621053
  • Publisher: Microsoft Press
  • Publication date: 10/18/2006
  • Series: Solid Quality Learning Ser.
  • Edition description: 2005 ed.
  • Edition number: 4
  • Pages: 466
  • Product dimensions: 7.36 (w) x 8.92 (h) x 1.19 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Foreword;
Acknowledgments;
Introduction;
A History of Inside Microsoft SQL Server;
Series Structure;
Examples and Scripts;
Topics Not Covered;
Caveats and Disclaimers;
How to Get Support;
Chapter 1: Installing and Upgrading to SQL Server 2005;
SQL Server 2005 Prerequisites;
Pre-Installation Decisions;
Getting Ready to Install;
To Migrate or Upgrade?;
Selecting Components;
Summary;
Chapter 2: SQL Server 2005 Architecture;
Components of the SQL Server Engine;
Memory;
Final Words;
Chapter 3: SQL Server 2005 Configuration;
Using SQL Server Configuration Manager;
System Configuration;
Final Words;
Chapter 4: Databases and Database Files;
System Databases;
Sample Databases;
Database Files;
Creating a Database;
Expanding or Shrinking a Database;
Using Database Filegroups;
Altering a Database;
Databases Under the Hood;
Setting Database Options;
Database Snapshots;
The tempdb Database;
Database Security;
Moving or Copying a Database;
Compatibility Levels;
Summary;
Chapter 5: Logging and Recovery;
Transaction Log Basics;
Changes in Log Size;
Reading the Log;
Backing Up and Restoring a Database;
Summary;
Chapter 6: Tables;
System Objects;
Creating Tables;
User-Defined Data Types;
IDENTITY Property;
Internal Storage;
Constraints;
Altering a Table;
Summary;
Chapter 7: Index Internals and Management;
Index Organization;
Creating an Index;
The Structure of Index Pages;
Index Space Requirements;
Special Indexes;
Table and Index Partitioning;
Data Modification Internals;
Managing Indexes;
Using Indexes;
Summary;
Chapter 8: Locking and Concurrency;
Concurrency Models;
Transaction Processing;
Locking;
Lock Compatibility;
Internal Locking Architecture;
Bound Connections;
Row-Level Locking vs. Page-Level Locking;
Row Versioning;
Other Features That Use Row Versioning;
Controlling Locking;
Summary;
Appendix : About the Author;
Appendix : Additional Resources for Developers;
Visual Basic 2005;
Visual C# 2005;
Web Development;
Data Access;
SQL Server 2005;
Other Visual Studio 2005 Topics;
Other Developer Topics;
Appendix : More Great Developer Resources;
Developer Step by Step;
Developer Reference;
Advanced Topics;
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted November 8, 2006

    Inside SQL Server: The Storage Engine

    Like it's predecessors this book is a must buy for any SQL Server DBA or Developer who requires more than a basic knowledge of the way the database storage engine works. A very well written book that is very readable, it contains information that can¿t be found in any other book.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 7, 2011

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)