That's odd, I would expect better performance because it can sniff the hardcoded value and use it for the query plan.

Perhaps the hardcoded value is not the same datatype as...

Why are you not memory capping SQL Server in order to leave some RAM reserved for OS / other applications ?

Have a look at https://www.sommarskog.se/query-plan-mysteries.html

Slow in app / fast in ssms symptom

Like when debugging you may have setted the variable to literals which sql server can sniff for a...

As you mention it happens in ssms too

it also coud be "parameter sniffing" https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/

Looks like "runs fast in ssms but slow in application"

check ms documentation https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-application-slow-ssms-fast

With modern storage I would skip index maintenance as Jef mentioned in that thread. So many layers and can be quite costly in the cloud

Most important is having correct statistics....

Sounds like what I've read earlier today about automatic tuning

Also, when a plan is forced , it is allow to compile longer?

https://littlekendra.com/2024/01/17/automatic-plan-forcing-could-be-great-but-isnt-sql-server/

https://www.brentozar.com/archive/2024/08/video-i-must-be-an-idiot-automatic-tuning-never-works-for-me/

https://dba.stackexchange.com/questions/339748/azure-sql-managed-instance-1-excessive-initial-compile-times-leading-to-app-ti

Dateformats ?

Empty or Invalid "To" when emailing ?

The latest thing thrown around is MS Fabric.

Found a page about the differences between Fabric and Dataverse https://fabriconelake.com/microsoft-fabric-vs-dataverse-comparison-for-microservices-and-data-management/ 

Our company is not that far yet to represent information as an unified...

Luckily not, didn't know that CrowdStrike existed before it happened

search on "token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission"

most articles mention logins & service principal names.https://blog.sqlauthority.com/2015/08/19/sql-server-login-failed-for-user-reason-token-based-server-access-validation-failed-with-an-infrastructure-error/ Mentions checking for deny permissions

That's how we did it. Most important things are the encryption keys

I've found https://www.sqlservercentral.com/articles/migrating-sql-server-reporting-services

To migrate from 2014 to 2016. 2016 to 2019 should be similar.

Don't have experience with scale-out.

Beware, from 2017/2019 MS disabled multiple SSRS instances on the same server

As we work on goodwill, please provide some sample data, the formatted query (like Phil did), expected results

DDL: tablestructure/views

Sampledata: insert statements

Query: formatted / human readable ( code tag?)

Expected results

Otherwise: have...

LOL "NOTE: No Refresh Buttons were abused in posting this message"