Inside Microsoft SQL Server 2005: The Storage Engine - Brossura

Delaney, Kalen

 
9780735621053: Inside Microsoft SQL Server 2005: The Storage Engine

Sinossi

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.
  • Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

    Informazioni sugli autori

    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.



    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.

    Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

    Altre edizioni note dello stesso titolo

    9788178531168: INSIDE MICROSOFT SQL SERVER 2005: THE STORAGE ENGINE

    Edizione in evidenza

    ISBN 10:  817853116X ISBN 13:  9788178531168
    Brossura