Blog Post

Modernization Best Practices and Reusable Assets Blog
8 MIN READ

Part 1 - Azure SQL DB Hyperscale Table Partitioning - Best Practices & Recommendations

diegoc's avatar
diegoc
Icon for Microsoft rankMicrosoft
Jan 31, 2023
Introduction Implementing table partitioning on a table that is exceptionally large in Azure SQL Database Hyperscale is not trivial due to the large data movement operations involved, and potential...
Updated Aug 23, 2023
Version 10.0
database platform cse
database platform cse – sql
KA_Rieshan101645's avatar
KA_Rieshan101645
Copper Contributor
Jun 24, 2024

Hi Diego Caracciolo,

 

Thanks for the detailed info.

 

May I know how to handle when the table is involved in transactional replication with CDC? If we need to partition this kind of setup when involved in Transactional replication or on Always-on databases with CDC how can we achieve implementing table parition without major outage?

 

Could you please provide some insights on this to tackle it or measure to be taken care off

 

Regards,

KA Rie