Some ANY Aggregate Transformations are Broken Paul White explores two cases where the introduction of the internal ANY aggregate by the optimizer may cause wrong results. Paul White ◆ July 1, 2019 8
If you are using indexed views and MERGE, please read this! Here is some information about an important MERGE "wrong results" bug, involving indexed views, that could be affecting the accuracy of your queries right now, and what options you have for working around the problem. Aaron Bertrand ◆ February 6, 2013 6