Populate dimension tables dynamically – Parts 1 & 2

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!