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

Category: Data Modeling

My views on data modeling

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
Moebius Strip

Table Pattern: Rotating Log / Ring Buffer

  • 2014-05-23
  • Data Modeling SQL Server Archive
  • No Comments
  • Patterns, SQL Server
Shooting yourself in the foot

Myth Busting Query Optimisation

  • 2013-07-01
  • Data Modeling Databases
  • No Comments
  • Performance, Query Plans, SQL Server
Column Store Feature Image

What is the Best Sort Order for a Column Store?

  • 2012-07-27
  • Data Modeling
  • No Comments
  • Compression, Data Warehouse, Statistics
Big-Big Tables join

Big/Big Table Joins

  • 2012-07-19
  • Data Modeling
  • No Comments
  • Parallelism, Performance
Deep Join

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
Column Store Feature Image

How do Column Stores Work?

  • 2012-07-04
  • Data Modeling
  • No Comments
  • BI, CPU, Memory, Performance, Relational
Information Staircase

The Information Staircase

  • 2012-07-01
  • Data Modeling
  • No Comments
  • Abstraction, Architecture, BI, Data Warehouse, ETL, Staging
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
123Next Page

Thomas Kejser

Fighting Bad Data Modeling

Copyright © 2021 - Thomas Kejser