ColumnStore Index in SQL Server 2016 and Azure SQL Database
The updateable clustered columnstore in Microsoft SQL Server 2016 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional B-Tree based schemas. This session assumes that you understand columnstore technology basics. We will do a deep dive into (a) strategies to load data leveraging minimal logging with concurrency (b) identifying/solving performance issues with queries (c) real-world best practices of keeping columnstore humming along.
Presenter Sunil Agarwal is a seasoned professional with 30+ years of industry experience in databases, Sunil has worked as a developer/lead in the relational database engine technology, a tool designer/lead building backup/restore tools, and as an application developer/manager enabling B2B commerce and e-learning. He has been in his role as a Principal Program Manager for SQL Server for the last 12+ years. Sunil has authored many technical white papers/blogs and has co-authored two books in SQL Server and presented database technologies in numerous national/international conferences. He enjoys teaching and has taught introductory programming courses at the University of Rhode Island and the University of Colorado.
Видео ColumnStore Index in SQL Server 2016 and Azure SQL Database канала In-Memory Technologies PASS Virtual Chapter
Presenter Sunil Agarwal is a seasoned professional with 30+ years of industry experience in databases, Sunil has worked as a developer/lead in the relational database engine technology, a tool designer/lead building backup/restore tools, and as an application developer/manager enabling B2B commerce and e-learning. He has been in his role as a Principal Program Manager for SQL Server for the last 12+ years. Sunil has authored many technical white papers/blogs and has co-authored two books in SQL Server and presented database technologies in numerous national/international conferences. He enjoys teaching and has taught introductory programming courses at the University of Rhode Island and the University of Colorado.
Видео ColumnStore Index in SQL Server 2016 and Azure SQL Database канала In-Memory Technologies PASS Virtual Chapter
Показать
Комментарии отсутствуют
Информация о видео
9 марта 2017 г. 5:01:58
01:02:23
Другие видео канала
Columnstore index in sql server (tutorial)SQL Server Execution Plan OperatorsSuccessful Production Deployments with Columnstore Index in SQL Server 2016 with Sunil AgarwalSQL SERVER IN-MEMORY OLTP: WHAT EVERY SQL PROFESSIONAL SHOULD KNOWBEST TRIVIA AND EMOJI GAMES! NOBODY CAN GUESS THE EMOJI CANDY!SQL Database Fundamentals - Video Columnstore IndexesModern Data Modeling with data lakes and Power BI datasetsSQL Server Quickie #40 - ColumnStore IndexesSQL Cursors - how and when to use themEpisode 2: Row vs Column StoreSQL Server Execution Plan BasicsSQL Tutorial 12: SQL Views & IndexReal Time Operational Analytics in SQL Server 2016ColumnStore Index In SQLIndexes in SQL Server | Use Indexes for Faster Search in SQL | SQL Interview QuestionsAzure Storage Tutorial | Introduction to Blob, Queue, Table & File ShareUnique and Non Unique Indexes in sql server Part 37MS SQL Server 2019 | How to create Database, SQL Login and UserHow Database Cursors Help in Fetching Large Result sets from your SQLMemory optimized tables for SQL 2014 and 2016