Myth Busting Query Optimisation 2013-07-01 Data Modeling Databases 8 Comments Performance, Query Plans, SQL Server
How Vertical Partitioning and Deep Joins Kill Parallelism 2012-07-16 Data Modeling 17 Comments Memory, Performance, Query Plans
Modeling Dimensions with History Tracked, Generic Attributes 2012-07-06 Data Modeling 5 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 12 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 5 Comments Data Warehouse, Predictability, Query Plans, SQL Server, Statistics
