It appears this thread has morphed into a Data Governance topic.  We have laws at the national, state, and local levels just as we should have data models at each...

The 15 circles and relationships diagram makes perfect sense to me.  My son and I have an ongoing joke that every training class, every conversation, every tutorial, all bypass step...

We really need to see your full SELECT statement to know how to optimize this although you mention your problem is mostly in maintaining this "PITA" in several procs and...

I currently use a table function to generate a range of numbers for joining to queries. I find it is easy for others to understand and is fast enough...

Simple. Just add a few cross joins for however many you need.

WITH x(y) AS (SELECT top (1000) ROW_NUMBER() OVER (ORDER BY s.object_id) FROM sys.objects s CROSS JOIN sys.objects t)

SELECT...

In an empty database I only got 97 numbers from sys.objects.

WITH x(y) AS (SELECT top (100) ROW_NUMBER() OVER (ORDER BY id) FROM sys.syscolumns s)

SELECT CASE WHEN y % 15 =...

I always use a ccyymmdd format such as '20161223' in all my scripts because it works regardless of many date settings. But, I suspect you have something else going...