Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).

Depending on the version of SQL Server, you...

Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).

Depending on the version of SQL Server, you might also...

Hi,

I am not very familiar about how sql server works behind the scenes but could it be that my query results are being saved somewhere on my local drive...

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

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 1 year 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'...