Strange. You are applying SP1, not SP2? http://www.sqlservercentral.com/articles/SQL+Server+2014/101274/

If it's one machine/drive, it's likely security. Try as Jeff suggested.

So many security issues in technology start with "no one will ever ..."

You would be amazed how easy it can be to de-anonymize data. When there is value...

Logged in, changed the avatar, and ready to go.

Hopefully with a better result than last year.

Show the calculations the, with a couple data sets. We can't see the requirements, and in code we can calculate this many ways. Without seeing what you are trying to...

Closing as this isn't a SQL 2016 question.

The version of  SSMS isn't relevant. The SQL Server database version is.

12GB is low, unless this is a small database and few users. I give instances 4GB often just for me.

What is  target server memory saying (Perf mon)?

The SPID would relate to the connection to SQL Server. A PoSh step doesn't necessarily make a connection to SQL Server. If this is running a long time, could it...

An article here.  But from what you've written, I'd expect this to work. I'll have to test and see if this works for me or fails as well....

What version of SQL Server? This is built in to SQL Server 2016. As for design, I'd look at Temporal Tables and how they are set up. If you are...