The Storage Engine
Inside Microsoft® SQL Server" 2005
Seiten
2006
|
4th edition
Microsoft Press,U.S. (Verlag)
978-0-7356-2105-3 (ISBN)
Microsoft Press,U.S. (Verlag)
978-0-7356-2105-3 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
"Inside SQL Server 2005: The Storage Engine" deals with computers/software.
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.
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.
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.
Installing & upgrading to SQL Server 2005 SQL Server 2005 architecture SQL Server 2005 configuration Databases & database files Logging & recovery Tables Index internals & management Locking & concurrency
Erscheint lt. Verlag | 11.10.2006 |
---|---|
Reihe/Serie | Resources for SQL Server |
Verlagsort | Redmond |
Sprache | englisch |
Maße | 187 x 235 mm |
Gewicht | 1000 g |
Themenwelt | Informatik ► Datenbanken ► SQL Server |
ISBN-10 | 0-7356-2105-5 / 0735621055 |
ISBN-13 | 978-0-7356-2105-3 / 9780735621053 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
Das umfassende Handbuch. Inkl. Analysis und Reporting Services
Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90 €