Can confirm with Jeff, sorry if I sounded a bit salty up there 🙂

How often does this data need to be replicated? Why do you feel the need to drop the development database to refresh the data?  Are there permission differences between the...

I call it a pound sign or a sharp sign.   The original name for it was a pound sign.. the origins of the "octothorp" which, btw, isn't even recognized by...

Never in my life have I heard somebody call a pound sign an octothorp .. spell check doesn't even recognize it as a word.

Interesting, returns some Null for me where there shouldnt be, but It makes sense..  I would point out that would necessarily give you the MAX it just gives you what...

My query should work for you then, hopefully somebody will come by with a smarter/more efficient query though.. I'd be interested in seeing the right way to do it.

If you do need the max value instead of the last value.. here is a very ugly query that somebody should probably yell at me for writing, its just the...

From my understanding, that is correct, SQL will use all the memory you allow it to use, if you want to know if you're allocating the proper amount there are...

So you want to show only orders where all items of the order have the status of shipped?

This might not be the "correct" way which may have been mentioned above...

If you already have a strong knowledge of SQL you can skip the MTA, I took it a couple years back and its  very much for beginners.   If you want...

Just as a side note, you can sometimes check if somebody or something else has the file open by going to Computer Management-> Shared Folder-> Open Files.

Are you using an AD account on this service or are you using a local machine service?

Migrating the master key is easy as long as you have the master key password, you just create that master key on the new instance OR you alter an existing...

I appreciate the response but no this is not the case here.. we arent using any sort of clusting or fail over AGs with this.

It is a SSRS 2016 on...

Note: Sorry, my grammar is not the best, horrible about run-on sentences. 😉