Viewing 4 posts - 1 through 4 (of 4 total)
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
October 7, 2015 at 2:02 pm
#1832125
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
#1736531
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
#1171674
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
#1171585