PLURALSIGHT OPTIMIZING OLTP AND DATA WAREHOUSING WITH SQL SERVER 2014 視頻教學 英文教學版




-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱:PLURALSIGHT OPTIMIZING OLTP AND DATA WAREHOUSING WITH SQL SERVER 2014 視頻教學 英文教學版
語系版本:英文教學版
光碟片數:單片裝
破解說明:
系統支援:For Windows XP/Vista/7
軟體類型:視頻教學
硬體需求:PC
更新日期:2014-02-28
官方網站:http://www.pluralsight.com/training/Courses/Description/optimizing-oltp-data-warehousing-sql-server-2014
中文網站:
軟體簡介:
銷售價格:$80元
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
　



　
軟體簡介:
　
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. 




-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=