Tomaz,

>>Furthermore, you can run the script on Azure SQL Server, Azure SQL Database, Azure MI and Azure Synapse.<<

I think this is a great effort, however you may want to fully...

Jeff/Grant,

I wonder if you guys noticed that the question is not about SQL Server, but rather APS? If you did not would your answers be any different?

Anthony

Just a correction for what it is worth: CDC is supported with Simple Recovery.

The ORDER BY in the ranking function only applies to the ranking function, so we cannot assume it affects the TOP operation in any way. The WHERE clause is just...

Thank you for the very good article.

One question I have, has to do with the need for an ORDER BY clause for the overall SQL statement in the first CTE...