Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden

Question

Post reply

Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden

Jeff Moden

SSC Guru

Points: 1004617
More actions
June 16, 2025 at 10:24 pm

#4608627

The LA Data Platform User Group had a necessary speaker cancellation for the group meeting on 18 June 2025. They fired a flare asking for a replacement speaker and I responded. And so I'm giving the presentation that's in the title of this post.
I had to limit the size of the abstract and so it's missing a lot of the stuff that's going to require a water cooled helmet. 😉 It's not that bad, though. I start with the very basics, introduce a whole bunch of concepts just in case they're not known, and the introduce the "impossible" but now super simple report and the "Black Arts" to keep it instantly up-to-date so that the return time for all 10 years is just a little over a quarter second. This presentation is appropriate for SQL Beginners and I promise that the experts won't get bored either. Here's the abstract for the presentation...
Learn how to produce an "impossible" temporal CROSSTAB report that’s ALWAYS up-to-date as soon as any changes are committed to a 10 year, 100 MILLION row, 50 GB table and it all occurs in about 270 MILLI-seconds (not a misprint... MILLI-seconds) while also learning how to avoid the need for a data-warehouse for such instant response capabilities. Ancillary information includes how to create and populate the 100 MILLION row table with “Random Constrained Data” using “Minimal Logging” and more.
Here's the link to the meeting/event where you can sign up to attend (free, of course).
https://www.meetup.com/ladataplatform/events/298093438/
The group is on "Pacific Time" and so the meeting will start on the East Coast at 10PM. They allocate 2 hours for these meetings.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SwePeso SSC-Dedicated Points: 39758 More actions · Answer 1

Please send me a pdf if possible.

The pre-aggregation sounds familiar

N 56°04'39.16"
E 12°55'05.25"

Jeff Moden SSC Guru Points: 1004617 More actions · Answer 2

SwePeso wrote:

Please send me a pdf if possible.
The pre-aggregation sounds familiar

It should sound familiar. You've reviewed this slide deck before. I've made some modifications but, as before, I've mentioned that you were the first person that I heard use the term.

If you want a copy of this latest one, send me a DM on LinkedIn... I don't have your email address.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)