If that error pops up when opening SSMS, I would try doing an uninstall and reinstall.  I would also check for free disk space and if you are on a...

We still have Windows XP computers that are "critical" to the company due to similar things.  In-house built software that is used for a product we are working to EOL...

My HOPE is that your application is throwing an error.  Since the application is known, you either have the source to it OR can contact the vendor to get them...

To add to your patching notes, it also falls under how much planned downtime can you get.  I have some systems that require maximum uptime and downtime on them is...

To add to what Phil said, my understanding is that ADS (Azure Data Studio) is more of a "development" tool and SSMS is more of a "management and administration" tool.

Deploying...

My opinion - VERY.  In general, what you are going to be doing the most of in SQL is NOT going to be CPU heavy operations but memory and disk...

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...