Generating Database Server-Side Cross Tabulations
If you are a DBA or a database programmer, your manager may have asked you to prepare a breakdown of employees by location and department, or a breakdown of products by category and provider. If your boss is a techie, instead of a breakdown she might have mentioned a pivot table, or, if she likes to use "the right words," a cross-tabulation, Giuseppe Maxia writes. Elsewhere on OnLamp.com another article advises on "Quick and Dirty RDBMS Tuning".