I’m on a training course this week and here are just two extracts from the workbooks.
Expressing grouped aggregates with derived tables allows ASE to “push down” the group predicates
ASE does NOT guarantee repeatable reads on non-deterministic, non-materialized (virtual) computed columns
I should hopefully be able to explain what they mean….
blm