Thank you to everyone that participated in T-SQL Tuesday #016: Aggregate Functions. I’d consider this a smashing success with 42 posts submitted!

I’d like to give a shout out to my posse for letting me host, and writing excellent posts. I’ve been on the site for four months now, and I’m loving it here.

A special thank you goes to the 13 Microsoft MVPs for sharing your expertise with us, especially since many of you were at Summit and had a busy week. MVPs are the cream of the crop – they are experts in the field, and they put their time and energy into the community, as well. Thanks for helping!

With that…drumroll please…

Forty-Two Blogs on Aggregation

Right out of the gate, Rob Farley, MVP (B | T) gave us The Blocking Nature of Aggregates. He describes the differences between Stream Aggregate and Hash Match with an easy-to-understand example of a card deck. Then, he demonstrates how the Aggregate transformation in SSIS works.

Mark Broadbent (B | T) was a firm believer that you don’t need a line of T-SQL to participate! He has aggregated a great list of training media in T-SQL Tuesday #016 – SELECT MediaType, SUM(Content) FROM #Sources GROUP BY MediaType.

Michael J Swart (B | T) In The Aggregate Function PRODUCT(), Michael shows us how to build a PRODUCT function, and how he uses it to calculate the value of the dollar after inflation.

Robert Davis, MCM (B | T) gives us examples of using aggregates to get information from an XML query plan in T-SQL Tuesday #16: Using Aggregate Functions in XML .

Nick Haslam (B | T) brings us a solid example of how he used PIVOT and aggregation to solve a complex data warehouse load in T-SQL Tuesday #016 – Taking it to the MAX.

Jacob Sebastian, MVP (B | T) A T-SQL Tuesday first-timer (yay!) brings us T-SQL Tuesday #016 – Summarizing data using GROUPING SETS(), a run-through of GROUPING SETS, with fantastic examples.

Bradley Ball (B | T) provides two scripts, one to get database size statistics, and another for table size statistics, in T-SQL Tuesday 16: Aggregation.

Jim McLeod (B | T) The burning question on Jim’s mind is “Can we reproduce columnstore indexes in SQL Server 2008?” Find out by reading Can We Reproduce Columnstore Aggregations in SQL 2008?

Luke Hayler (B | T) is a man after my own heart with a Reporting Services 2005 discussion about row groups, column groups and their scope in T-SQL Tuesday #016 – Aggregations. Excellent examples, Luke!

Robert Matthew Cook (B | T) learns something new when he researches CLR Aggregates for T-SQL Tuesday #016 Aggregate Functions #tsql2sday .

Noel McKinney (B | T) uses CHECKSUM_AGG to determine changes in checksums in a group, for loading a DW. T-SQL Tuesday #016 – Aggregation Functions

Jason Strate, MVP (B | T) is improving query performance – significantly! – by aggregating in a correlated subquery. He shows us how in Aggregating With Correlated Sub-Queries #tsql2sday.

Ted Krueger, MVP (B | T) is deleting data (oh noes!) in T-SQL Tuesday #016 – COUNT and DELETE duplicates. Thankfully, it’s just duplicate data, and never should have been there in the first place.

Matt Velic (B | T) gets a gold star for reinforcing the basics of aggregation with a look back at one of the American film greats, John Hughes, in T-SQL Tuesday 16: Aggregate the 80s . Also, my favoritest favorite John Hughes movie has to be Uncle Buck. Or maybe The Great Outdoors. Or maybe Weird Science. He was so full awesome, it’s hard to pick.

Denis Gobo, MVP (B | T) gives thorough examples of how to chart intraday and end-of-day stock market data. Interesting stuff! T-SQL Tuesday #016 Grouping Market Data With T-SQL

Bob Pusateri (B | T) has a solution for people that don’t have time or money for SSAS in A Poor Man’s Data Warehouse. Also: bacon gets an honorable mention here.

Pinal Dave (B | T) A student’s question prompted this quick-but-informative post: SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL).

Jen McCown, MVP (B | T) serves up some of my favorite T-SQL tricks, like OVER (PARTITION BY) and CTEs in T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!.

Andy Lohn (B | T) uses CHECKSUM_AGG to verify the data in static tables across different environments in T-SQL Tuesday #016 – The Power of the CHECKSUM_AGG.

Gill Rowley (B | T) gets mathy and creates a factorial function! T-SQL Tuesday #16 – Aggregate Functions & Factorials(!)

Kelly Martinez (B | T) shows us how to use PIVOT like a pro! T-SQL Tuesday #16: PIVOT

Oscar Zamora (B | T) has outstanding examples of OVER, PARTITION BY and RANK for Windowed Functions empowering analytics [#TSQL2sday].

Dev Nambi (B | T) walks us through finding MEDIAN, PERCENTILE and COVARIANCE. T-SQL Tuesday #16: Statistics using CLR Aggregates

Doug Lane (B | T) Another man after my heart with a Reporting Services post, Doug asks if RS datasets are indexed in T-SQL Tuesday #016: Aggregations in Reporting Services.

Sean McCown, MVP (B | T) I’ve never heard of PowerShell scripts referred to as “cute”, until Sean wrote T-SQL Tuesday #016: Get DB Sums With Powershell.

Claire Willett (B | T) T-SQL Tuesday 016 – When is yesterday, exactly? Claire tells us, “Despite only taking up 20% of the week, Mondays are kind of important.” She then shows us how she used aggregates with dates to pull data for the current business day and previous day.

George Mastros, MVP (B | T) walks us through the how of Understanding SQL Server 2000 Pivot with Aggregates .

Ricardo Leka (B | T) A quick but effective script to show blocked processes: T-SQL Tuesday #016 – Blocking Processes – #tsql2sday.

Jason Brimhall (B | T) T-SQL Tuesday #016: Aggregates and Statistics. First, I learned something new: what a “quartile” is. And he used OVER – a favorite! Jason shows us how to use MAX and OVER to properly size production databases.

Andy Leonard, MVP (B | T) proves there are multiple ways to do the same thing with T-SQL Tuesday: Aggregations in SSIS!

Allen White, MVP (B | T) More PowerShell! Allen implements security best practices, POSH and aggregates in one fell swoop: T-SQL Tuesday #016:Check Your Service Accounts with PowerShell.

Amit Banerjee (B | T) gives us examples of using aggregates for performance monitoring: T-SQL Tuesday #016 : Aggregate Functions .

Brad Schulz, MVP (B) T-SQL Tuesday #016: AWF-Inspiring Queries Brad, who appears to missing a letter in his last name (ha! Had to, Brad!), walks an order through an identity crisis with the help of window functions.

Tom Powell (B | T) Tom shows us the fine points of both functions in Aggregation – Getting Totals And Subtotals With ROLLUP And CUBE.

Thomas Rushton (B | T) shows us how to check backup sizes. Then he shows us a better way. In the same post! T-SQL Tuesday #16 – Aggregates and Average Weekly Backup Sizes

Aaron Bertrand, MVP (B | T) String concatenation, six ways: which IS the best? Find out in T-SQL Tuesday # 16 : This is not the aggregate you’re looking for.

Stuart Ainsworth (B | T) gives us a simple, effective method to find the first of an item in #TSQL2sday: Emulating a FIRST aggregation.

Ken Johnson (B | T) tackles aggregates from a more philosophical perspective with The Absolute Best.

Stacia Misner (B | T) shows us how to use AGGREGATE in Retrieving Aggregate Data from Analysis Services for Reports.

Naomi Nosonovsky (B) talks about how to perform a PERCENT() function in T-SQL Tuesday #016 – TOP N Percent for the group.

Josh Feierman (B | T) Tips! Tricks! Performance Monitoring! MDX! Yes, all of this in one place at Fun With Aggregation – TSQL2SDay #16.

Steve Jones, MVP (B | T) Last, but certainly not least, Steve shares a TRUE STORY of how aggregation is ALMOST equal to aggravation – but he worked around it in the end! T-SQL Tuesday #016 – Aggregation


We made it! Thank you, Adam Machanic, for letting me host. I learned a ton this month, and it was great to get the opportunity to work with so many great bloggers.

High fives all around!