You could try a powershell script to delete items older than x days

https://stackoverflow.com/questions/17829785/delete-files-older-than-15-days-using-powershell

Happy Christmas and joyous end of the year.

Be safe, sound, happy in 2024

Thanks for the challenge

it's called parameter sniffing https://blog.sqlauthority.com/2019/12/19/sql-server-parameter-sniffing-simplest-example/

Can't help you much with that, mine succeeded. What error message did you get

Have you tried run as admin, disabling antivirus ...

We don't use it actively because bimlscript is still...

A degree shouldn't be necessary,  but it does prove that you had some discipline to learn something. You can prove that otherwise as well.

Most of the time we have a...

There is a ssis-extension for VS2022 https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

Can you elaborate a bit. Reversed=same quantity?

What is the relation of

O1                              C3         ...

Most people on the forum won't open attached items.

Can you provide the DDL-scripts of the tables involved?

Create table model.IMETA_ZTRB_BRACS_Model_TA_BW3

(...)

Create table dim.IMETA_Master_Currency_Data_TA_BR ...

Can you provide sample data

INSERT INTO model.IMETA_ZTRB_BRACS_Model_TA_BW3  values ....

Can...

The substring causes the scan, every value hof comm_value need to be looked at and computed.

Options: filtered index (if possible)

Add a new column to C_B_PARTY_COMM and keep it up to...

Check [ReportServer].[dbo].[Catalog] in the reportserver database

Backup before & test

You can rename the itempath with an update statement and remove it using the gui

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