Clustered Index vs. Heap 2014-01-12 SQL Server Archive No Comments Keys, Patterns, Performance, Scale, SQL Server
Why You Need to Stop Worrying about UPDATE Statements 2012-04-27 Data Modeling No Comments Data Warehouse, FusionIO, Keys, Patterns, Performance, Relational, SQL Server
Exploring Hash Functions in SQL Server 2011-11-06 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Hashing, Keys, Performance, Scale, SQL Server
Why Surrogate Keys are not Good Keys 2011-10-22 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Relational
Boosting INSERT Speed by Generating Scalable Keys 2011-10-05 Grade of the Steel SQL Server Archive No Comments I/O, Keys, OLTP, Performance, Scale, SQL Server
Physically Placing the Maps in the architecture 2011-08-19 Data Modeling No Comments Architecture, Data Warehouse, ETL, Keys, Maps, Master Data, Staging
Transforming Source Keys to Real Keys – Part 2: Using Maps To Fix Key Problems 2011-08-15 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Maps, Master Data, Staging, Type2
Transforming Source Keys to Real Keys – Part 1: Introducing Map tables 2011-08-04 Data Modeling No Comments Data Warehouse, ETL, Keys, Maps, Master Data, Staging
An Overview of Source Key Pathologies 2011-07-30 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Keys, Master Data, Staging
Good keys, what are they like? 2011-05-13 Data Modeling No Comments Data Warehouse, Keys, OLTP, Relational