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

 



 
軟體簡介:
 
ThiscoursefocusesonSQLServer2014andtwoofthelatestadditionsto
thedatabaseengine.Wefirstlookathowtheshiftintechnologytrends
establishedtheneedforadifferentbreedoftechnologies.Columnar,or
Column-Oriented,databaseshavebecomeincreasinglypopularindatawarehousing
applicationsbecausetheyallowforbettercompressionandmulti-foldperformance
improvements,andwe'llseehowSQLServer2014implementsthiswithclustered
columnstoreindexes.Inaddition,astechnologymakesabiggershiftinhardware
tomulti-coreCPUarchitecturesandlargeamountsofmemoryareevencheaper
andmoreattainable,it'simportantforsoftwaretoadjustandutilizethese
changes.We'llseehowIn-MemoryOLTPaddressesthesetrendsandmore,letting
youcreatetablesinmemory,eliminatinglocksandimplementingoptimistic
multi-versionconcurrency.ThiscoursediscussesindepthIn-MemoryOLTP(memory
optimizedtables),previouslyknownasHekaton.We'llcovercreatingmemory-
optimizedtables,loadingdata,durabilityandtheaffectthathasonthe
transactionlog.We'llalsolookatindexingindetail,explainingthenew
indextypescreatedspecificallytosupportIn-MemoryOLTPandhowandwhen
toapplyeachtypebasedonyourusecaseandwe'lldiscusshowIn-Memory
OLTPandClusteredColumnstoreindexescanfitavarietyofapplicationswhile
comparingthemwitheachotherandtraditionaldisk-basedtablesandindexes.