June 11, 2009 03:11 PM
CLR-Based Solution for Running Aggregates
Good performance for large partitions
Rating:
(0)
SQL Server Magazine
InstantDoc ID #102097
Executive Summary:
If performance is your main goal in running aggregates, you should use a set-based solution with very small partition sizes; otherwise, you should use a Common Language Runtime (CLR)-based solution.
|
Author’s Note:
I’d like to thank Adam Machanic, Dejan Sarka, and Eladio Rincón for providing preliminary code samples and advice regarding the CLR-based solutions. |
In the...
You must be a paid Professional Member to access this entire article.
Already a Professional Member? Please log in now: