Blog Post

Azure Synapse Analytics Blog
3 MIN READ

Multi-Column Distribution for Dedicated SQL pools is now GA!

mariyaali's avatar
mariyaali
Icon for Microsoft rankMicrosoft
Mar 22, 2023
We are excited to announce that Multi-Column Distribution (MCD) for Azure Synapse Dedicated SQL pools is now Generally Available in the latest DW release! MCD is highly desirable for easing migration...
Updated Oct 17, 2023
Version 5.0
Synapse SQL
koushikcs09's avatar
koushikcs09
Copper Contributor
Jul 25, 2023

I tried to run the attached query mentioned in the blog post, but I encountered an error. Here are the details of my SQL Server environment:

  • SQL Server Management Studio: 19.0.20209.0+f9a9d8f6
  • SQL Server Management Objects (SMO): 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
  • Microsoft T-SQL Parser: 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
  • Microsoft Analysis Services Client Tools: 16.0.19993.0
  • Microsoft Data Access Components (MDAC): 10.0.19041.3208
  • Microsoft MS: 3.0 6.0
  • Microsoft .NET Framework: 4.0.30319.42000
  • Operating System: 10.0.19045

Despite having the latest versions of these components, I'm still unable to create a clustered index multiple columns. I would appreciate any guidance or suggestions on how to resolve this issue.