Please use

INSERT INTO dbo.PrimaryHist (columnlist) SELECT

instead of INSERT INTO dbo.PrimaryHist SELECT

in case columns get rearranged

Have a look at UPDATE triggers with #inserted #deleted to compare differences

https://stackoverflow.com/questions/19737723/log-record-changes-in-sql-server-in-an-audit-table

there are gotcha's if you use IF UPDATE(...)

The UPDATE() function does not discriminate whether the value has changed or not,...

Same question as https://www.sqlservercentral.com/forums/topic/trigger-to-track-changes

Rowlock: https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table?view=sql-server-ver16#rowlock

If you get blank pages when exporting to pdf , something is getting outside your margins.

Take a copy of the report and work on it till it fits back in...

IndexOptimize: are you only updating statistics ? or also doing index maintenance (you may skip index maintenance)

The name resemples Ola's

https://dba.stackexchange.com/questions/197532/ola-index-and-update-stats#:~:text=There%20is%20a%20third%20scenario%2C%20where%20you%20can,%3D%20NULL%2C%20%40UpdateStatistics%20%3D%20%27ALL%27%2C%20%40OnlyModifiedStatistics%20%3D%20%27Y%27%3B

There is a third scenario, where you can only update statistics, using...

As you mention it is splitted across pages, something must be overflowing the page size.

You could try rectangles to keep things together.

Please provide some T-SQL statements tabledefinition , the sampledata and expected results based on that sampledata.

So we can copy paste & execute it in ssms without typing.

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