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: Query Plans

Shooting yourself in the foot

Myth Busting Query Optimisation

  • 2013-07-01
  • Data Modeling Databases
  • No Comments
  • Performance, Query Plans, SQL Server
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
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
Statistics Blog Logo

The Ascending Key Problem in Fact Tables– Part one: Pain!

  • 2011-07-01
  • Grade of the Steel SQL Server Archive
  • No Comments
  • Data Warehouse, Predictability, Query Plans, SQL Server, Statistics

Thomas Kejser

Fighting Bad Data Modeling

Copyright © 2022 - Thomas Kejser