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.
Business Metrics Alignment: Business Intelligence Across Departments
Managers want timely, visual and personal information for faster decisions. Business metrics alignment is where Business Intelligence helps most, because every department’s metrics support the corporate objective.
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.