April 22, 2009 10:22 PM
Subqueries and Joins for Running Aggregates
Use these solutions for small partitions
Rating:
(0)
SQL Server Magazine
InstantDoc ID #101623
Executive Summary:
Both the subquery and join solutions perform reasonably well for calculating running aggregates when you have very small partitions. Because the subquery-based approach requires a separate scan of the data for each aggregate, the join approach is best for calculating multiple aggregates.
|
...
You must be a paid Professional Member to access this entire article.
Already a Professional Member? Please log in now: