Viewing 5 posts - 1 through 5 (of 5 total)
>>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...
October 24, 2022 at 7:08 pm
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?
October 7, 2015 at 2:02 pm
If you need Simple Recovery, for whatever reason, then CDC won't do it
Just a correction for what it is worth: CDC is supported with Simple Recovery.
August 8, 2014 at 12:54 pm
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...
May 24, 2010 at 10:53 am
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...
May 24, 2010 at 8:21 am