購物須知
結帳櫃檯
手動下單
訂單查詢
站内搜索
軟體破解
下載目錄
問題反映
常見問題
加入最愛
xyz軟體王

xyz軟體王

xyz軟體王

您現在的位置:網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 碟片詳情
PLURALSIGHT OPTIMIZING OLTP AND DATA WAREHOUSING WITH SQL SERVER 2014 視頻教學 英文教學版
碟片編號:TIC2809
碟片數量:1片
銷售價格:200
瀏覽次數:34483

轉載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.




購物清單
※您必須購物滿500元