מה צריך לדעת לפני
שתתחיל

מתחיל 4 June 2026 13:11

נגמר 4 June 2026

00 ימים
00 שעות
00 דקות
00 שניות
course image

Columnstore Indexes in 2017-2019

Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.
PASS Data Community Summit via YouTube

PASS Data Community Summit

6076 קורסים


1 hour 16 minutes

שדרוג אופציונלי זמין

Not Specified

התקדמות בקצב שלך

Conference Talk

שדרוג אופציונלי זמין

סקירה כללית

Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.

סילבוס

  • 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

נושאים

Conference Talks