Scott, it seems you forgot what is the controversy we're discussing.

I'm saying that EOM (end of period) date is absolutely useless, and the date of the beginning of next month...

Wasn't it answering your question?

https://www.sqlservercentral.com/Forums/FindPost1920045.aspx

Below86

The only thing I can say is that low scale of the project is no excuse for lame design implemented in your system.

Every piece you just described is a design...

It does not matter for the optimiser in a join.

Range definitions don't affect the choice of plans.

I wrote pretty complicated reports where different products had different aggregation periods.

My joins looked...

For an address "2/56 Rice Road" what would be the interpretation?

And what if it's "Apt.22 2/56 Rice Road" ?

Say we have your table with only beginning dates. Now I want to join to that table. I have to retrieve the next row to do the join. Admittedly not...

When there are thousands of lines of code that are based of EOM date it sure would make it confusing for one person(or more) to change how the date logic...

Sometimes when joining, it's easier if the ending value is in the row itself. It's not necessarily the end of the world to include an ending value in the row....

Do you really expect PAON part of an address to be changed over time?

Because I cannot see any other reason for not saving PAON and SAON parts once they are...

Do you save extracted SAON and POAN parts o addresses?

So many solutions of different quality to the problem which should never be attempted!

Jeff asked a question at the very beginning, but the topic got spammed by numerous solutions which...

You welcome.

But it still gonna be too much waste.

Size of backups is only a part of the issue.

Ok.

See it for yourself.

Go to your local/DEV instance of SQL server.

Create 2 empty...

OK, let's clarify the matters first.

JSON are not originated from a DB table. So, they cannot be moved out of the table. They should not be put in there.

Then, according...

Yes, of course.

First, you have to keep JSON and XML messages our of SQL...

Do roads in Michigan look like this one?

https://youtu.be/-mqZ_OZVx7I