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 No Comments Patterns, SQL Server
Myth Busting Query Optimisation 2013-07-01 Data Modeling Databases No Comments Performance, Query Plans, SQL Server
What is the Best Sort Order for a Column Store? 2012-07-27 Data Modeling No Comments Compression, Data Warehouse, Statistics
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
How do Column Stores Work? 2012-07-04 Data Modeling No Comments BI, CPU, Memory, Performance, Relational
The Information Staircase 2012-07-01 Data Modeling No Comments Abstraction, Architecture, BI, Data Warehouse, ETL, Staging
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