Inside Microsoft® SQL Server™ 2005: The Storage Engine

Inside Microsoft® SQL Server™ 2005: The Storage Engine image
ISBN-10:

0735621055

ISBN-13:

9780735621053

Author(s): Delaney, Kalen
Edition: 2005 ed.
Released: Oct 21, 2006
Publisher: Microsoft Press
Format: Paperback, 464 pages
to view more data
Sell this Book
Rent this Book
Find in Library

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.

    • Low Price Summary

    ‌
    ‌
    ‌
    ‌
    ‌

    Top Bookstores

    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    ‌
    We're an Amazon Associate. We earn from qualifying purchases at Amazon and all stores listed here.

    DISCLOSURE: We're an eBay Partner Network affiliate and we earn commissions from purchases you make on eBay via one of the links above.

    Want a Better Price Offer?

    Set a price alert and get notified when the book starts selling at your price.

    Want to Report a Pricing Issue?

    Let us know about the pricing issue you've noticed so that we can fix it.