Another title for this session might be "Converting Rows to Columns" or "How to turn data into information".

Whether you're a Data Analyst, Report Creator, Developer, or DBA, this is an essential skill that you'll need to do in the future if you haven't had to already. Here's what we'll learn:

Primary Goal:
How to convert rows to columns to make a pivoted result, sometimes referred to as a "Cross Tab" and do it in a nasty fast manner using the "Cross Tab" and "Pivot" methods.

Ancillary Learning:
1. Introduction to building large volumes of random constrained data to test with.
2. Introduction to "Minimal Logging" to build the test data even faster and without ticking off the DBA.
3. Introduction to "Pre-Aggregation" as a simple first step towards increasing performance.
4. Introduction to "Divide'n'Conquer" methods for more performance.
5. Seemingly "Duplicate Indexes" for insane performance.