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 LessThanDot.com 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.
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 .
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.
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!
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.
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
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(!)
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.
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.
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.
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.
Stacia Misner (B | T) shows us how to use AGGREGATE in Retrieving Aggregate Data from Analysis Services for Reports.
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!