Not sure why it displays double ??

Wikipedia contains an overview of western codepages https://en.wikipedia.org/wiki/Western_Latin_character_sets_(computing)

https://en.wikipedia.org/wiki/Code_page_850

Looks like is is due memory limitations in the earlier days of MS-DOS

Thanks for the story glhohman

What do you mean exactly with but how do I format this for SSRS?

SSRS has date functions http://venkateswarlu.net/MSBI/ssrs/SSRS_Common_Functions_Date_Time.aspx

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