I'm thinking that "everything changes" when you're using a remote connection but don't know for sure.  I supposed "It Depends" on the connection settings.  If you've come across connection settings...

Another possibility along with the known problems of compression and page splits is that you may have a shedload of indexes that are all doing the same deadly dance.

That is very likely your biggest problem.  If you're updating pages and the updates are "ExpAnsive" (the rows get bigger), then you run into rampant...

Just make damned sure that you know who can access your stuff on the cloud.  A lot of people don't setup security right.  There's been more than one instance of...

I've got to disagree about SQL Server not being good about code reuse and say "It Depends".  And it really depends when it comes to views because they're frequently written...

You'll probably get some responses if you make the data you posted "readily consumable".  Please see the link in my signature line below for one way to do that.

Also, all...

I know it's not the answer you're looking for but the two items above...

be aware, that adding dates / times only works with the DATETIME data type but not with the new (ANSI compatible) DATETIME2 (this would cause Error 8117: Operand data...

You could at least apply enough attention to...

I guess I don't understand the need for the parameters of BOTH, LEADING, and TRAILING.  Apparently the industry standard has changed over time because, for me, TRIM() always meant both...

We can't see your logs.  You should post the errors...

Good lord... talk about a...

Actual_DateReceivedVendor
201804250        10256
201805023128.57        10256
201806143103.09        10256
201808023120.19 ...

To add to what Sue has stated, LEN doesn't include trailing spaces in its count.  Here's the note from Books Online.  The emphasis is mine.

Returns the number of characters of...

That and something that would work like "Query Designer on Steroids" where you would simply select a stored procedure and it would generate an ERD for each section of code...