TPC-H: Schema and IndexesTPC-H: Schema and IndexesTPC-H: Schema and IndexesTPC-H: Schema and IndexesTPC-H: Schema and Indexes 2014-06-30 Data Modeling No Comments Performance, SQL, TPC-H
Table Pattern: Rotating Log / Ring Buffer 2014-05-23 Data Modeling SQL Server Archive 9 Comments Patterns, SQL Server
Myth Busting Query Optimisation 2013-07-01 Data Modeling Databases 8 Comments Performance, Query Plans, SQL Server
What is the Best Sort Order for a Column Store? 2012-07-27 Data Modeling 8 Comments Compression, Data Warehouse, Statistics
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
How do Column Stores Work? 2012-07-04 Data Modeling 9 Comments BI, CPU, Memory, Performance, Relational
The Information Staircase 2012-07-01 Data Modeling 1 Comment Abstraction, Architecture, BI, Data Warehouse, ETL, Staging
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
