Just to add to the previous comments. I upgraded a system from SQL 2012 to SQL 2019 RDS on AWS. One of the most impactful actions after identifying slow-running queries...

SELECT 
    CASE 
        WHEN DATEDIFF(SECOND, crtDte, GETDATE()) < 60 THEN 'Just Posted' 
   ...

Oh yes, I was looking...

UPDATE MM2WO
SET sDesc = TRANSLATE(sDesc, '&<!>!-=', '      ')
WHERE ...

https://learn.microsoft.com/en-us/sql/t-sql/functions/translate-transact-sql?view=sql-server-ver16

Check the 3 underlying views.  If they're all pulling from the same tables, it might be worth while to crib some of the code and write a...

Check the 3 underlying views.  If they're all pulling from the same tables, it might be worth while to crib some of the code and write a separate query,...

Your query is probably trying to access all the tables at the same time and on a not very powerful machine with a slow disk it might be slowing it...

Heh... pretty typical for things like this.  The OP asks a question and then never participates in their own thread.  While some great code has been posted, there are...

Have you tried rebuilding the clustered index?

.

• This reply was modified 2 years, 9 months ago by Jonathan AC Roberts. Reason: duplicate

Try installing the table valued function here: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

Then to select 15 minute intervals as in your example:

SELECT Value
  FROM dbo.DateRange('1900-01-01 00:00', '1900-01-01 23:59'...

Why do you say "Expected output would be something along these lines"?

You only have 6 rows in your input data, surely it can't be too difficult to type the expected...

So what is the output you are expecting from that input?

All you need to do is provide a list of the rows you expect from your input.

The outputs you have...

So what is the output you are expecting from that input?

Also, there is an error in your script. Surely it isn't difficult to paste it into SSMS and check it...

It's quite simple really. All we want is a short script that creates the input data, then the results you expect from that input data.