@skeleton56

you could try to clone the xp to a vhd-file that can be mounted by hyper-v https://learn.microsoft.com/en-us/sysinternals/downloads/disk2vhd

for win 8.1, probably has to do with SMB v1 being disabled for...

As far as I know you can't really throttle linked servers

Thanks for the update, but our biml tools BIML Express Varigence doesn't seem to work wit VS 2022. Is BIML still actively developed. Is there an alternative for BIML Express...

• This reply was modified 1 years, 9 months ago by Jo Pattyn. Reason: tool used

Looks that SOS_SCHEDULER_YIELD is a benign wait. The cpu was fully utilized

What is the parallelism setting for this query?

If maxdop= 1  results in 1 vcpu /32 vcpu = 3% of...

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