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

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

Speaker Bio
Jeff Moden, progenitor of the term “RBAR”, identifies himself as an “Accidental DBA”. He’s written 49 mostly five-star articles for SQLServerCentral . com and, having more than 59,000 posts, is the leading contributors on that site. Jeff is renowned for being able to teach extremely complex concepts and techniques in such a manner that even beginners can understand without boring the experts. He’s also a 9-year SQL Server MVP veteran, won the Red Gate exceptional DBA award in 2011, and has spoken at the PASS Summit, many SQL Saturdays, and many local PASS chapter meetings on many different SQL Server subjects. His mantra is “Performance is in the code ”