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: Statistics

Trace Flag 4136

  • 2014-09-13
  • SQL Server Archive
  • No Comments
  • EAV, SQL Server, Statistics
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
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

When Database Statistics are not Enough – Search Patterns

  • 2012-02-21
  • Data Modeling Databases
  • No Comments
  • Histogram, I/O, Patterns, SQL Server, Statistics
Statistics Blog Logo

The Ascending Key Problem in Fact Tables –Part two: Stat Job!

  • 2011-07-07
  • Grade of the Steel SQL Server Archive
  • No Comments
  • Data Warehouse, Histogram, Predictability, SQL, SQL Server, 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