M: Inside, microsoft, sQL, server tM ) 2005: The Storage Engine.
Topics also include security details, with coverage of the new SQL Server 2005 security model, and data protection through the backup and restore algorithms. With pragmatic advice, best practices, extensive code samples, and table examples, developers and database administrators will find the guidance they need to better understand how to build powerful, efficient databases. Kalen Delaney, 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. Develop CLR user-defined types and learn about temporal support in the relational model. This documentation is archived and is not being maintained.
Upgrade or migrate to SQL Server 2005 and choose configuration options Control space allocation for databases and files manually or automatically Manage transaction.
Indeed, the author is a MS SQL MVP and has written with the collaboration of those who wrote the code for MS SQL 2005 at Microsoft. 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.