Performance Optimization for OLAP Workloads in SQL Server
MP4 | Video: AVC 1920 x 1080 | Audio: AAC 44 Khz 2ch | Duration: 01:02:10 | 317.96 MB
Genre: eLearning | Language: English
This video helps you to design databases and processes that can manage millions or billions (or more) rows of data for analytics and reporting. Analytic workloads follow different architectural and query patterns than standard transactional systems, and the associated data stores grow differently over time as compared to online transaction-processing systems. This video covers the purpose, usage, and effects of growth on analytic data stores with a focus on storing the data directly in SQL Server.

continue reading…