Just trying to eyeball your deadlock, it looks like the deadlock is caused by a python script. Quick review of the deadlock XML, it kind of looks like you are...

I know a lot of discussion has already happened on this, but I wanted to point out that it would be nice to see the actual vs estimated execution plan....

As far as I am aware, you can make the SSIS package in newer versions of VS, you just can't deploy IF the version is too new.

For example, I have...

Have you tried connecting by IP instead of server name set up in the hosts file? I am wondering if SQL Server Engine doesn't "trust" the hosts file and is...

One thing to point out though about the hashing approach and indexing on it though - is that index useful? You likely are not searching by the hash and are...

To add to this, settings for parallelism are not some "magic" number that can be applied across any environment. If it could be recommended with little to no information, then...

Yep. Lets say you are doing an update on a table or insert which requires an exclusive lock on the table. Having the query go parallel creates self-blocking as you...

Another thing - is there a query hint to put the MAXDOP to another value? I know you can set that at the instance level, database level, and query (or...

Your powershell is wrong for that. Your convert to HTML call is happening outside of your loop. You will need your convert to HTML to be inside the loop AND...

The only thing I can think of is user permissions. Likely something with permission chaining or delegating permissions (not sure if those terms are correct, but I think so). I...

Possibly a dumb question but is your new laptop domain joined and on the corporate network (VPN or on site)?

xp_cmdshell runs server side so you would need to be able to browse the directory from the server side not your local dos command line.

My opinion though - SQL Server...

I did a quick google on that wait type as I had never seen it and was curious and it sounds like it is not exactly related to memory, but...

Just want to point out that requesting a teams meeting with complete strangers on a forum because you are having trouble with a report is a very uncommon thing to...

SQL jobs run as the SQL agent service account. It does NOT run as "sa". That is why you are getting the error. You will notice the error does NOT...