Sign up to save your library
With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.
Share
Find this title in Libby, the library reading app by OverDrive.
Search for a digital library with this title
Title found at these libraries:
| Library Name | Distance |
|---|---|
| Loading... |
This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.
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
Share
