Subscribe to this blog
Archives: November 2010
PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or CTE statements over large volumes of data with Max Degree of Parallelism <> 1
The ROW_NUMBER() or RANK() were incorrectly marking records within a partiton, and that behaviour was nondeterministic.
Let's… Read more
3 comments, 628 reads
Posted in aedna@SQL on 3 November 2010