You need to switch your perspective on how you approach the data.  You seems to be looking at it from the "many" side of a relationship.   Conceptually, there are no...

Apparently with some data types or some SQL versions, some columns may be duplicated with a sysname datatype.  I've submitted an update to the original script, but it may take...

I would consider updating once daily to be sporadic, rather than a traditional OLTP model.  It is feasible to create a process to handle updating the data and then clean-up...

Updates to a column store are not a good idea.  Column store handles Inserts just fine, but Updates and Deletes slow the entire table access down.  Column stores were made to...

BETWEEN on a character column works different than it would with numeric or date/time columns

'0'
'1'
'111111111'
'2'
'2222222'

WHERE col BETWEEN '1' AND '2'
would return:

1 month != 30 days != 4 weeks.  Make sure you understand the impact the different intervals can have on your data.  Also be aware of the how the between clause...