Winning with Column Store in SQL Server 2016 - A Customer Story

Winning with Column Store in SQL Server 2016 - A Customer Story

PASS Data Community Summit via YouTube Direct link

Summary

22 of 22

22 of 22

Summary

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Winning with Column Store in SQL Server 2016 - A Customer Story

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Technical Assistance
  3. 3 SQL Server Migration Assistant (SSMA)
  4. 4 Business Scenario Graphic
  5. 5 Initial Situation
  6. 6 Migration Challenges
  7. 7 Dealing with Partitioning Differences
  8. 8 Best Practices for Migrating to SQL Server
  9. 9 Data Loading Audit Report
  10. 10 NCI: Non-Clustered Index (Rowstore)
  11. 11 Deltastore Basics
  12. 12 CCI: Clustered Columstore Index
  13. 13 Index Compatibility
  14. 14 Initial Changes to SQL 2016 Database / Server
  15. 15 Changes on SQL 2016 Side
  16. 16 Traditional DW Design
  17. 17 Fact Table
  18. 18 Related Tables
  19. 19 The Contestants
  20. 20 Test Results
  21. 21 Future Considerations
  22. 22 Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.