| http://www.w3.org/ns/prov#value | - When I have some time, I am going to try testing some of the queries in your articles to see the results firsthand.here is a question related to the ProductVersion queries in this discussion:... analytic functions (ROW_NUMBER or DENSE_RANK) are more efficient due to the overhead of building a DISTINCT list ...You are saying that the CROSS APPLY query takes a performance hit for high-cardinality data
|
