I MAY be mistaken on this, but I think that an i9 is a desktop processor not a server processor. Generally, you would want to have SQL Server running on...

You just need to make your font smaller if it doesn't fit 😛

BUT even if you...

That is VERY hard to read and consume...  But stripping out everything prior to the line of *'s, fixing a bad piece of formatting,  and running it through a SQL...

To add to what Phil is saying - I would try it out and see what happens.  Basically, run your code and then either SELECT or PRINT @Where to see...

Looks like you changed the post after ratbak replied?

What I would recommend is rather than executing the dynamic SQL, print it so you can see exactly what will be run...

A few ways I can think of to fix this.  I think the BEST solution to fix it is to change the SQL Server Agent service to be an AD...

Is there a reason you don't want to do it from the web interface?

Offhand, I am not sure how to remove them using rs.exe or any other utility, but I...

Wouldn't that be related to parameter sniffing in the scenario I gave vs function in a WHERE clause in the OP?  And if so, the performance could tank due to...

Without seeing any of your data or datatypes, I am really just guessing, but I would be willing to bet that it is related to your group by statement on...

Offhand, the best way I have found to search for it is to use SQL Search OR to script out all of the jobs and do a search in those. ...

Yeah, I wasn't saying it was "good", it is just what it was doing.  I prefer the "WHERE (A=@a) OR (@a IS NULL)" approach myself... and depending on how often...

if @Parameter3 is null, then use table1.id2.

My first step would be to load up the execution plan on both systems and make sure they look similar, if not identical.

Next, I would check for blocking while your...

I am a bit confused why this is dynamic SQL and what you are trying to do.  You have 2 stored procedures that appear to be unrelated.  The first uses...

As a thought - is your master database valid (ie not corrupt) prior to installing that update?  I would run checkdb on it and verify that it is valid as...