can you post a deadlock xml so we can look at it.

as well as the code involved in writing-reading that log table

not much you can do here other than rewrite that view (and likely the views contained within it).

likely best thing is to see what really needs to be retrieved and...

if you tried to upload a sqlplan here it won't work - you need to use https://www.brentozar.com/pastetheplan/ and share the link to it here

but one thing you can take for granted - all currently supported versions of the software you mentioned work in all currently supported versions of Windows (and in some *Nix)...

Thanks for the advise.

If you don't mind me asking - why do you advise that? I'm not disagreeing, I'm asking because I'm new to Powershell and interested to learn.

I...

just noticed this was part of a SQL Agent step.

word of advise - NEVER EVER use powershell directly on a step - either code it in C# on a SSIS...

change process so that you use staging tables (not tempdb!!!) for each task - and you switch in/out of these and it is also where you do your inserts (so...

it is possible to load a DLL that is NOT in the GAC - have a look at the following

https://cultivatingsoftware.wordpress.com/2018/08/21/ssis-load-dll-gac/

https://blog.matrixpost.net/load-an-custom-assembly-in-sql-server-integration-services-ssis-script-task-that-is-not-or-cannot-be-stored-in-the-gac/

There is an app that was sending DML requests from a SQL2016 to SQL2008, and we saw lots of issues and it could have been driver related where record...

instead of trying now to follow a different approach why don't you tell us, very detailed, what you are trying to accomplish with having some software inserting those sql statements...

too many things to consider in order to say if there is a more efficient way - depends on volumes and number of times it is executed as well if...

works fine with a few caveats

performance impact will depend on your activity and server spec - bad server with lots of activity and it will be noticeable.

using a custom view/proc...

your problem is that your "ltrim" is on the wrong place, and the string compare inside does not find the required matches)

following works

drop table if exists #employee
CREATE...

you have 2 issues to address.

1 - if your destination datatype is a date then your variable assignment needs to cast it as a datetime, not as a string -...

you most likely have the Azure agent still active on your server (these are installed by default on the azure vm's depending on how they are created - or on...