You can also use a computed column for as_of_month, there's no need to physically store it again. as_of_date date NOT NULL, as_of_month AS CONVERT(varchar(6), as_of_date, 112), That column is...

I like the synonyms, maybe with an Agent job that does the work to check/repoint. I'd think the Java app wouldn't need to know, just load the empty table....

I blame professors are unis for this....

Your original post clearly defined what you wanted to do.  It also acts as pseudo-code for what needs to be written.  When you run into something like this, at least...

And, David, thank you for the Ron Jeffries link... in particular, I really like his post on technical dept (included below).

https://ronjeffries.com/articles/019-01ff/tech-debt/

Again, there is no button that could give your...

Where I work the dashboards and performance metrics for production applications and infrastructure is available to all in all environments. Being told something is one thing.  Being shown is...

A couple of things there...

First, there's that Cost Threshold of Parallelism thing.  5 is way too low.  I have a mixed OLTP and Batch Processing system and I've found the...

The NAME of the synonym would be whatever the original table was before you...

BWAAA-HAAA!  I've actually not heard that one before, David.  I'm going to remember that one!

Shifting gears a bit and on the subject of people saying "There is no "I" in...

Too funny.

On a similar note, I'm not one to use Hungarian Notation (Phil Factor calls it "tbl-ing") for object names but I ran into a bit of a dilemma quite...

while it's slightly off topic, I worked with a  team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of...

Heh... I was in the military a long time ago.  I got used to strange names that had weird abbreviations.  Even my Dad had to put up with some of...

Thanks for the feedback, rVadim.

So... enquiring minds want to know... did the link help you or not?

Hi! I'm no really sure I am doing this correctly. I am not running anything by database and already have an existing table. The first one attached is what...