會員登錄
軟體搜尋
您的位置： 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
商品詳情
|
商品編號：TIC2809 碟片數量：1片 銷售價格：200 瀏覽次數：37430 
【轉載TXT文檔】 |
您可能也喜歡：
DVD27697--零基礎玩轉Linux+Ubuntu實戰視頻課程 MP4格式 中文教學版(DVD一片裝)
DVD6694--Loopmasters Marshall Jefferson House Generation 英文正式版(Loopmasters出品的音樂樣本集)
DVD16525--TutsPlus PSD To WordPress Minimal Portfolio Theme 視頻教學 英文教學版(DVD一片裝)
DVD11002--CBT Nuggets Cisco CCVP CIPT2 Exam Pack 642.456 英文正式版(CISCO教學)(DVD一片裝)
TIC2542--PLURALSIGHT TEST FIRST DEVELOPMENT PART 1 視頻教學 英文教學版
商品描述
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.