Populate dimension tables dynamically – Parts 1 & 2

SQL Server

April 8^th, 2022

Populate dimension tables dynamically – Parts 1 & 2

April 8^th, 2022

I wrote two tips around what you can do when a table that stores the same strings over and over again has grown to an unmanageable size: create a dimension table!

Populate dimension tables dynamically in SQL Server – Part 1
Populate dimension tables dynamically in SQL Server – Part 2

As an interesting side note, these were my 200th and 201st tips on MSSQLTips.com!

By: Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.