Inside Microsoft® SQL Server™ 2005: The Storage Engine (Developer Reference)

4.07 avg rating
( 27 ratings by Goodreads )
 
9780735621053: Inside Microsoft® SQL Server™ 2005: The Storage Engine (Developer Reference)
View all copies of this ISBN edition:
 
 

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" may belong to another edition of this title.

    From the Author:

    Key Book Benefits:

    - Delivers practical, hands-on guidance for understanding and making the most of the architecture of SQL Server storage, including logging and recovery, indexes, tables, transactions and locking, and security - Provides deep background information that helps developers better understand how to build more responsive databases that have fewer vulnerabilities - Features numerous code samples, table examples, practical advice, and best practices

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

    "About this title" may belong to another edition of this title.

    Top Search Results from the AbeBooks Marketplace

    1.

    Kalen Delaney
    Published by Microsoft Press (2006)
    ISBN 10: 0735621055 ISBN 13: 9780735621053
    New Paperback Quantity Available: 1
    Seller:
    Ergodebooks
    (RICHMOND, TX, U.S.A.)
    Rating
    [?]

    Book Description Microsoft Press, 2006. Paperback. Condition: New. 2005 ed.. Seller Inventory # DADAX0735621055

    More information about this seller | Contact this seller

    Buy New
    US$ 30.44
    Convert Currency

    Add to Basket

    Shipping: US$ 4.99
    Within U.S.A.
    Destination, Rates & Speeds

    2.

    Delaney, Kalen
    Published by Microsoft Press (2006)
    ISBN 10: 0735621055 ISBN 13: 9780735621053
    New Paperback Quantity Available: 2
    Seller:
    Murray Media
    (North Miami Beach, FL, U.S.A.)
    Rating
    [?]

    Book Description Microsoft Press, 2006. Paperback. Condition: New. Never used!. Seller Inventory # P110735621055

    More information about this seller | Contact this seller

    Buy New
    US$ 37.55
    Convert Currency

    Add to Basket

    Shipping: US$ 1.99
    Within U.S.A.
    Destination, Rates & Speeds