Dataminds Belgium 10/11 oktober was great

I can't really help but can you give some more sideinformation

Any change in used Oracle drivers? 12c to 19?

Any change in Oracle executions plans ( 12c to 19)

Does SSIS or...

If you're working with the preview version I would contact MS about it SSMS 18.12.1 is the latest general availability (GA) version

You could use a T-SQL cursor to loop through the months and return a dataset per month

You could retrieve the data all at once

select id,count(*),mymonth.id

from dataset

join mymonths on dataset.date between...

Our developers are not trained in writing stored procedures but they are getting better in taming the ORM. Mostly inline SQL

Teams is really catching on in our organization. Recent features made it easier to exchange with external persons. The ability to link to a chat in CRM sped up the...

Have a look at dbatools Start-DbaXESmartTarget https://docs.dbatools.io/Start-DbaXESmartTarget

Sounds something for the last_value function https://www.sqltutorial.org/sql-window-functions/sql-last_value/

You may get a quicker response if you paste the TSQL-scripts to reproduce the testcase

so we can run it in a "test" database without...

I guess the table scan is seqid from db2. Strange that is isn't an index scan. Is that the table or is that the one of the top-clusterindex scan

The not-in...

As Ken said, stall's are usually an infrastructure thing. (network, san, ...)

Could also be due a new query plan generating a heavier load

The server is cpu-bound -> find the most...

As Phil said, provide an easy digestable  testcase. So it can run on a test system to reproduce the solution. You've already shared a screenshot

You can mock the tablenames/values as...

Isn't a hardware fault.

Resource_semaphore:

SQL Server decided on an execution plan that requires more memory.

http://blog.sqlgrease.com/how-to-fix-resource_semaphore-waits/#:~:text=Typically%20RESOURCE_SEMAPHORE%20waits%20occur%20as%20a%20result%20of,need%20tuning%20%28i.e.%20adhoc%20queries%2C%20new%20code%20releases%29.

https://www.sqlskills.com/help/waits/resource_semaphore/

Add more server ram or  since you're on sql server 2017, you can use query...

I gues as many times your subreport is called ( the distinct values?) + 1 for the main report

Not sure if it's related but occasionally we have corrupt subscriptions. Those have a double datasource

check

select 
DataSource.DSID DatasourceID
,DataSource.Name DatasourceName
,Subscriptions.[SubscriptionID] SubscriptionID
,Subscriptions.Description SubscriptionName
,Reports.Name RerportName
,Reports.Path ReportPath
from [ReportServer].[dbo].[DataSource] DataSource
left join [ReportServer].dbo.Subscriptions...

Thanks for the start article. Installed the libraries from the resources in the SSRS GAC. Also copied them to ReportServer\bin folder.

Todo: reportbuilder