購物須知 |  常見問題 |  軟體破解 |  問題反應 |  加入最愛 |  查看購物車
xyz軟體王 新品上架 手動下單 查看購物車

xyz軟體王

xyz軟體銀行

當前位置: 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
會員登錄
最新上架
商品分類

商品詳情

PLURALSIGHT OPTIMIZING OLTP AND DATA WAREHOUSING WITH SQL SERVER 2014 視頻教學 英文教學版
商品編號:
本站售價:NT$200
碟片片數:1片
瀏覽次數:34194

轉載TXT文檔】  

您可能感興趣:

您可能也喜歡:

商品描述


 



 
軟體簡介:
 
This course focuses on SQL Server 2014 and two of the latest additions to
the database engine. We first look at how the shift in technology trends
established the need for a different breed of technologies. Columnar, or
Column-Oriented, databases have become increasingly popular in data warehousing
applications because they allow for better compression and multi-fold performance
improvements, and we'll see how SQL Server 2014 implements this with clustered
columnstore indexes. In addition, as technology makes a bigger shift in hardware
to multi-core CPU architectures and large amounts of memory are even cheaper
and more attainable, it's important for software to adjust and utilize these
changes. We'll see how In-Memory OLTP addresses these trends and more, letting
you create tables in memory, eliminating locks and implementing optimistic
multi-version concurrency. This course discusses in depth In-Memory OLTP (memory
optimized tables), previously known as Hekaton. We'll cover creating memory-
optimized tables, loading data, durability and the affect that has on the
transaction log. We'll also look at indexing in detail, explaining the new
index types created specifically to support In-Memory OLTP and how and when
to apply each type based on your use case and we'll discuss how In-Memory
OLTP and Clustered Columnstore indexes can fit a variety of applications while
comparing them with each other and traditional disk-based tables and indexes.




..::我的購物車::..