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

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