An introduction to the Rollup Clause in SQL Server, which aggregates at several levels of a hierarchy. A population table by country, state and city shows how.
Data Mining Algorithms (Analysis Services – Data Mining)
I quite often receive requests for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.
SQLAuthority News – TechDays Session at Infosys Mysore 2009 – Change Data Capture and PowerPivot
Notes from my TechDays session at Infosys Mysore in December 2009, where I presented Change Data Capture and PowerPivot to a smart, curious crowd.
Staging, Warehouse and Mart: Why Three Layers
Staging, warehouse and mart give data loads, trusted history, and focused reporting separate jobs; learn when each layer earns its place.
SQL SERVER – Business Intelligence – Aligning Business Metrics
Managers want timely, visual, personal information for faster decisions. How Business Intelligence helps with aligning business metrics across a company.
SQL SERVER – 2008 Star Join Query Optimization
Star Join Query Optimization in SQL Server 2008 Enterprise Edition uses bitmap filtering to speed up data warehouse queries that join fact tables.
Pre-Aggregating Data for Fast Dashboards
Pre-aggregating data can make dashboards fast through summary tables or indexed views when grain, refresh, and reader consistency are clear.