Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
ISBN: 0735621055
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 115
Pages: 115
Authors: Kalen Delaney
- Inside Microsoft SQL Server 2005: The Storage Engine
- Table of Contents
- Copyright
- Foreword
- Acknowledgments
- Introduction
- 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
- About the Author
- 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
- More Great Developer Resources
- Developer Step by Step
- Developer Reference
- Advanced Topics
- Index
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
ISBN: 0735621055
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 115
Pages: 115
Authors: Kalen Delaney