Fighting Bad Data Modeling
  • About Me
    • Musing
    • Game Guides
  • Subject Areas
    • Data Modeling
    • Databases
    • Programming
  • Resources
    • Database Conventions
    • Source Code
    • Free Data
    • Utilities
    • Slides
  • SQL Server Archive
    • Courses
      • Performance Tuning Course
      • Data Warehousing Course
    • Grade of the Steel

Tag Archives: Historizing

Modeling Dimensions with History Tracked, Generic Attributes

  • 2012-07-06
  • Data Modeling
  • No Comments
  • Data Warehouse, Dimensional Models, Historizing, Predictability, Query Plans
Radiation no digging

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

Why Surrogate Keys are not Good Keys

  • 2011-10-22
  • Data Modeling
  • No Comments
  • Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Relational
Zombie vs Sheep

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

Thomas Kejser

Fighting Bad Data Modeling

Copyright © 2021 - Thomas Kejser