What is the Best Sort Order for a Column Store? 2012-07-27 Data Modeling No Comments Compression, Data Warehouse, Statistics
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
When Database Statistics are not Enough – Search Patterns 2012-02-21 Data Modeling Databases No Comments Histogram, I/O, Patterns, SQL Server, Statistics
The Ascending Key Problem in Fact Tables –Part two: Stat Job! 2011-07-07 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Histogram, Predictability, SQL, SQL Server, 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