Myth Busting Query Optimisation 2013-07-01 Data Modeling Databases No Comments Performance, Query Plans, SQL Server
How Vertical Partitioning and Deep Joins Kill Parallelism 2012-07-16 Data Modeling No Comments Memory, Performance, Query Plans
Modeling Dimensions with History Tracked, Generic Attributes 2012-07-06 Data Modeling No Comments Data Warehouse, Dimensional Models, Historizing, Predictability, Query Plans
Why “Date BETWEEN FromDate AND ToDate” is a dangerous join criteria 2012-06-29 Data Modeling No Comments Data Warehouse, Dimensional Models, Histogram, Historizing, OLTP, Query Plans, Statistics
The Ascending Key Problem in Fact Tables– Part one: Pain! 2011-07-01 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Predictability, Query Plans, SQL Server, Statistics