SQL Server 2014 Design & Programming

Kalman Toth

  • 出版商: CreateSpace Independ
  • 出版日期: 2014-05-12
  • 售價: $1,720
  • 貴賓價: 9.5$1,634
  • 語言: 英文
  • 頁數: 820
  • 裝訂: Paperback
  • ISBN: 1499529597
  • ISBN-13: 9781499529593
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

#1 bestseller Microsoft SQL Server 2014 Design & Programming book. SQL Server 2014 design & programming builds on achievements of decades in advanced relational database technology. Among the new SQL Server 2014 features is prominent: in-memory OLTP tables. Disk was always the slowest part of the computer system. Since memory is abundant, it is logical to place tables into memory to gain in performance. Programming SQL Server 2014 is fun due to the host of marvelous tools available for the developer in SQL Server Management Studio and Visual Studio. Graphical query designer, for example, helps the developer to develop the JOIN structure of a complex query. SQL Server 2014 provides a highly productive environment for database software development. SQL Server 2014 introduces 3 new database design features: in-memory OLTP tables, inline index declaration in CREATE TABLE statement and updateable clustered columnstore indexes. In-memory OLTP aims to boost performance by reducing disk io as memory capacities are expanding frequently beyond the size of the database. SQL Server 2012 columnstore indexes are static. Updateable columnstore index expands the applicability of the performance feature. Inline index declaration elevates indexes to the level of PRIMARY KEY, FOREIGN KEY, CHECK constraint and DEFAULT constraint which can be declared inline.

商品描述(中文翻譯)

#1 暢銷書《Microsoft SQL Server 2014 設計與程式設計》。SQL Server 2014 的設計與程式設計建立在數十年先進關聯式資料庫技術的成就之上。其中一個新的 SQL Server 2014 功能是顯著的:內存 OLTP 表格。磁碟一直是電腦系統中最慢的部分。由於內存豐富,將表格放入內存中以提高性能是合乎邏輯的。在 SQL Server Management Studio 和 Visual Studio 中,開發人員可以使用許多神奇的工具來編程 SQL Server 2014,這使得編程變得有趣。例如,圖形化查詢設計器可以幫助開發人員開發複雜查詢的 JOIN 結構。SQL Server 2014 為資料庫軟體開發提供了一個高效的環境。SQL Server 2014 引入了三個新的資料庫設計功能:內存 OLTP 表格、在 CREATE TABLE 語句中的內聯索引聲明和可更新的叢集列存儲索引。內存 OLTP 旨在通過減少磁碟 IO 來提高性能,因為內存容量經常擴展到超過資料庫的大小。SQL Server 2012 的列存儲索引是靜態的。可更新的列存儲索引擴展了性能功能的應用範圍。內聯索引聲明將索引提升到主鍵、外鍵、CHECK 約束和 DEFAULT 約束的級別,可以在內聯聲明中聲明。