Hi,

I found this article interesting, since partitioning is not a subject I have much experience with. I see that the more experienced users have found some errors/shortcomings. But for a "partitioning beginner" like me, you seem to have highlighted some interesting points.

It seems as if PartitionID is crucial when it comes to the performance of the query. One thing struck me: Using a while loop in combination with a table variable shouldn't, in general, be the best performing option.

How would this query perform:

SELECT <something>

FROM <the partitioned table>

WHERE etp.PartitionID <= 10

It might be that it's just as expensive as the other examples in your article?

..Håvard..