商品描述
Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.
Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.
Pro SQL Server Internals does the following:
- Explains how to design efficient database schema, indexing, and transaction strategies.
- Shows how various database objects and technologies are implemented internally and when they should or should not be used.
- Demonstrates how SQL Server executes queries and works with data and transaction logs.
商品描述(中文翻譯)
《Pro SQL Server Internals》解釋了不同的 SQL Server 組件如何在「幕後」運作以及它們之間如何相互通信。這是一本實用的書籍，包含大量範例，將向您展示各種設計和實施決策如何影響系統的行為和性能。
《Pro SQL Server Internals》涵蓋了多個 SQL Server 版本，從 SQL Server 2005 一直到最近發布的 SQL Server 2014。您將了解 SQL Server 2014 的新功能，包括新的基數估算器（Cardinality Estimator）、內存 OLTP 引擎（代號 Hekaton）和集群列存索引（Clustered Columnstore Indexes）。透過《Pro SQL Server Internals》，無論您使用的是哪個版本和版本的 SQL Server，您都將擁有一個堅實的路線圖，以理解 SQL Server 數據庫後端的深度和強大功能。
《Pro SQL Server Internals》提供以下內容：
- 解釋如何設計高效的數據庫架構、索引和交易策略。
- 顯示各種數據庫對象和技術的內部實現，以及何時應該或不應該使用它們。
- 演示 SQL Server 如何執行查詢以及如何處理數據和交易日誌。
