Pretend T-SQL BI Queries

Often times there is no cube, no OLAP, no BI plan but someone wants reports that provide rollup data, data slices, sums, and even dimensional representations that are oriented toward the BI world. Of course building these in SQL is possible, even easy sometimes, but it slams the processing of an RDBMS. When working through... Continue reading →