Session

Columnstore Indexes in SQL Server 2022 from zero to a hero!

A clustered columnstore index (CCI) is usually the best choice providing optimal query performance for almost large tables. I am using columnstore indexes since SQL 2012 and have written several articles. I will demonstrate real time life scenarios of using CCI to store analytic data efficiently like: analytics, data science, experiments results, DW, logging & Audit, reporting and analytics. Real- time analytics on OLTP be done with CCI indexes. By default, Synapse Analytics creates a CCI. I will Cover
• Batch & Row Execution and using query store to check performance
• Delete and Update Operations
• Bulk Loading Data
• Segment and Rowgroup Elimination
• Partitioning
• Nonclustered Columnstore Indexes on Rowstore Tables
• Nonclustered Rowstore Indexes on Columnstore Tables
• Maintenance & Performance
• Columnstore Indexes on Temporary Tables & Memory-Optimized tables
SQL 2022 new features : Columnstore and Batch Mode Improvements:
• Ordered Clustered Columnstore Index
• Columnstore String Improvements
• Vector Extension to Improve Batch Mode
• Columnstore Segment Elimination Enhancements
This is a demo session only with minimum theory & lessons from the fields!
https://www.youtube.com/watch?v=BKsngBKCfNA

Yitzhak David

DBA BDA POWER BI NOSQL K8s

Nahariyya, Israel

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top