會員登錄
軟體搜尋
您的位置： 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
商品詳情
|
商品編號：TIC2809 碟片數量：1片 銷售價格：200 瀏覽次數：37971 
【轉載TXT文檔】 |
您可能也喜歡：
TIC0418--Gnomon Analog Training TRAINING Video-Dusso VOL I Dvdrip 英文教學光碟正式版 (Dusso主講遮罩繪畫教學)
DVD10515--Video2Brain CINEMA-Special Architektur-Compositing Professionelle 2D 3D Bildkompositionen 英文正式版(教學)(DVD一片裝)
TIC0498--Movie FX Vol 5 DVDRip 英文教學光碟正式版 (電影特技效果教程)
CB0771-4--Keystone J2EE JDBC and Servlet Programming 英文光碟正式版 (4片裝)
TIC1644--Lynda com iWork 09 New Features 英文正式版(Apple iWork 09 新功能教學)
商品描述
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.