Search
InstantDoc ID
GO

Browse By: Author | Issue

July 20, 2009 05:20 PM

Using Nested Iterations and the OVER Clause for Running Aggregates

Determine the best solution depending on partition size
Rating: (0)
Itzik Ben-Gan
SQL Server Magazine
InstantDoc ID #102336
Executive Summary:
Until Microsoft SQL Server supports the OVER clause, your best solutions for running aggregates are a set-based solution using subqueries or joins, for very small partition sizes, or a CLR data reader–based solution, for large partitions.


...

...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

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 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.