शुरू करने से पहले आपको क्या जानना चाहिए
आप शुरू करें

शुरू होता है 4 June 2026 15:25

समाप्त होता है 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