會員登錄
軟體搜尋
您的位置： 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
商品詳情
|
商品編號：TIC2809 碟片數量：1片 銷售價格：200 瀏覽次數：37059 
【轉載TXT文檔】 |
您可能也喜歡：
DVD11001--Train Signal System Center Operations Manager 2007 R2 DVD1 英文正式版(System Center Operations Manager 2007教學)(DVD一片裝)
TIC1581--Groovebox Training Ableton Live 7 Explained Vol.2 英文正式版(Ableton Libe 音樂軟體教學軟體)
DVD14085--Lynda com Mixing a Rock Song in Pro-Tools 教學 英文正式版(DVD一片裝)
DVD1281--Vilppu tudio Drawing Manual Chapter 10 Indirect Lighting 英文光碟正式版 (DVD版)
DVD6684--I3D Tutorials Introduction To Polygon Modeling 英文正式版(i3D Tutorials 推出的教學 Polygon Modeling 入門教學)
商品描述
PLURALSIGHT OPTIMIZING OLTP AND DATA WAREHOUSING WITH SQL SERVER 2014 視頻教學 英文教學版
軟體簡介:
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.
軟體簡介:
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.