Search
InstantDoc ID
GO

Browse By: Author | Issue

April 22, 2009 10:22 PM

Subqueries and Joins for Running Aggregates

Use these solutions for small partitions
Rating: (0)
Itzik Ben-Gan
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.

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Very good explanation about the details os SQL Server.
I would love if the articles comes with a rate that indicate it's level, something simple like (begginer, intermediate, advanced) would be wonderful.

Take Care!

MarcosGalvani 5/20/2009 10:34:17 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.