I'd say that SQL Server 2016 is probably what I'd consider the best, with SQL Server 2008 R2 being second best.  The problem I have with 2012, 2014, 2017 is...

This can't be the whole criteria for matching records, or else the results would have 9 rows for STOCK = 5, and you say you want the results to have...

I think we need some clarification on what is actually happening here and what you're trying to do.  How are you matching IN records with their corresponding OUTE record?  I'm...

I've always tended to do ELT, without even realizing it, because so many of the ETL tools are difficult to get anything accomplished.  For me, it's usually a question of...

Why are databases good companions?
Because they always maintain their relationships, and they aren't afraid to commit.

A query walks into a bar, goes up to two tables and says "mind if I join you?"

While this may have good intentions, I certainly would not have this script create the databases and would not have this as a scheduled job.  Since it uses the missing...

OK, based on this and your previous posting, I believe we're back to having SQL Server reinstalled on your PC.  When they get to the "Database Engine Configuration" page of...

unfortunately you may be stuck having to reinstall SQL Server on your machine, or trying the process described here for restarting it in single user mode:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out

if you can connect to this using the Object Explorer in SQL Server Management Studio, try to right click on the instance name, then select the "Security" page.  The first...

Is it possible that calling this through sp_updatestats vs UPDATE STATISTICS is using a different sampling size?  The docs say sp_updatestats will use the default sampling if 'resample' is not...

0x54686973206973206D6F72652066756E207468616E20746865204573706572616E746F20746872656164207761732E
😀

It sounds like since this is just on your machine they should have added your login as an Administrator.
This is done in the Setup wizard on the "Database Engine...

Somehow I don't think that setting the database to trustworthy is really the long term solution you're looking for.  There are lots of articles that talk about the security problems...