Sunday, November 05, 2006

Get expert architectural insights for building and maintaining robust databases.

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.

• 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

Topics are really jiucy ;-) I mean mouth watering, rush for your copy.

Let me know your views on this book.

Related link: http://www.amazon.com/gp/product/0735621055/sr=1-1/qid=1156801743/ref=sr_1_1/104-6313703-3867159?ie=UTF8&s=books

Cheers,