That's a big jump, somewhere around sql 2014 the optimizer plan generation changed.

Have you tried different compatiblity modes?

Have you checked https://www.sommarskog.se/query-plan-mysteries.html

*edit*

as you are on SQL 2019, have you enabled querystore...

Scripting: using dba-tools https://docs.dbatools.io/Find-DbaInstance.html

System administrators usually have an inventory tool

You could start with the Microsoft assessment toolkit https://www.mssqltips.com/sqlservertip/7428/microsoft-assessment-and-planning-toolkit-inventory-sql-servers/

Scripting: probably using wmi

Consider the latest version of sql server to upgrade to. Depending on your acceptance cycle it will have matured out at the end.

Upgrade to 2019: stable. Will be out of...

http 500 = internal server error

Check the report server configuration, is there an url configured?

Check the various logs for clues

Kakavotas7, consult the people who created the database if you want the meaning. Could be a hardcoded value or a reference to another field / parameter table

You could try convert(binary(32),'text',1)

DECLARE @Myvalue5 binary(32)=convert(binary(32),'0x0000000000000000000000000000000000000000000000000000000000002000',1)
SELECT @Myvalue5

CAST and CONVERT (Transact-SQL) - SQL Server | Microsoft Learn

You could try the maxdop hint to avoid parallellism

I really should have a sticky on Jeff Moden's post about the (non)-sense of generic rebuilding / reorganizing indexes.

A lot of resources are consumed during the reindex with little or...

If you are having troubles with SSL, check URLRoot in reportserver.config. Like when using powerbi reporting server.

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver16#bkmk_URLReservations

<UrlRoot></UrlRoot>

By default it starts in  Report Server url: https://server/ReportServer

Troublesome with SSL wildcard *.domain.com.

<UrlRoot>https://server.domain.com/Reportserver</UrlRoot&gt;

Start...

Can you elaborate why the partitioning is requested. Because of sideloading data without blocking?

SQL Server uses statistics in order to choose what approach is best. Usually an appropriate index achieves...

from https://learn.microsoft.com/en-us/answers/questions/1045928/best-practice-to-decide-partition-table-in-sql-ser

It completely depends on how you use the tables.

There are 2 main benefits of partitioning:

Partition elimination on queries

Partition swapin/out for data loading/purging

For partition elimination, the partition must be included...

Not really a clue why it would be slower

Patchlevels of the SSIS box? Power saving options?

Are you using the right url?

• Web Service Url: plaintext meant for services

  • https://server/ReportServer

• Web Portal url: fancy meant for end-users

  • https://server/Reports

I prefer giving access to views, for the reasons you give in 1 & 2.

View definition only needs to change when it is no longer compatible with its tables