What You Need to Know Before
You Start

Starts 6 July 2025 14:57

Ends 6 July 2025

00 Days
00 Hours
00 Minutes
00 Seconds
course image

Columnstore Indexes in 2017-2019

Join us to delve into the latest advancements of Columnstore Indexes in SQL Server 2017-2019. This session emphasizes the performance enhancements tailored for Data Warehouses and Business Intelligence (BI) solutions. Gain insights into the newly introduced features and essential fixes designed for high-scale environments, ensuring optimized p.
PASS Data Community Summit via YouTube

PASS Data Community Summit

2825 Courses


1 hour 16 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Conference Talk

Optional upgrade avallable

Overview

Join us to delve into the latest advancements of Columnstore Indexes in SQL Server 2017-2019. This session emphasizes the performance enhancements tailored for Data Warehouses and Business Intelligence (BI) solutions.

Gain insights into the newly introduced features and essential fixes designed for high-scale environments, ensuring optimized performance and efficiency.

Syllabus

  • Introduction to Columnstore Indexes
  • Overview of Columnstore technology
    Benefits of using Columnstore Indexes in SQL Server
  • Enhancements in SQL Server 2017
  • Adaptive Query Processing
    Batch Mode Execution Improvements
    Automated Columnstore Index Maintenance
  • Enhancements in SQL Server 2019
  • Scalar UDF Inlining
    Intelligent Query Processing enhancements
    Data Virtualization support
  • Performance Improvements for Data Warehouses
  • Real-world scenarios and performance benchmarks
    Optimization techniques for large-scale data warehouses
    Hybrid Transactional/Analytical Processing (HTAP)
  • New Features for Business Intelligence Solutions
  • Columnstore Indexes in Power BI and other BI tools
    Improvements in analytical query processing
    Scaling BI solutions with Columnstore Indexes
  • High-Scale Environment Considerations
  • Best practices for high-scale data solutions
    Monitoring and troubleshooting Columnstore Index performance
    Case studies and practical examples
  • Advanced Features and Fixes
  • Handling large data volumes efficiently
    Use of Incremental Statistics
    System and user feedback improvements
  • Conclusion and Future Developments
  • Summary of key takeaways
    Possible future trends and developments in Columnstore technology
    Resources for further learning and exploration
  • Hands-on Labs and Assignments
  • Creating and optimizing Columnstore Indexes
    Performance tuning exercises
    Real-world data scenarios with SQL Server 2017-2019
  • Q&A and Troubleshooting Session
  • Open forum for questions and troubleshooting specific issues
    Review and discussion of participant challenges and solutions

Subjects

Conference Talks