If you are sure you always want it to seek the values you can give the query a hint:

SELECT *
  INTO #SROISDPL
 ...

You need a colon after numbers:

def calculate_sum(numbers):
    total = 0
    for num in numbers:
       ...

As Jeff said partitioning is the best way and fastest way to remove large chucks of data by date.

When you want to regularly remove old data from a database, there...

Paste it into Excel and create a line chart then add a trend line.

Here is something to get you started:

WITH CompanyData AS 
(
    SELECT * FROM (VALUES
        ('[24]7 Customer, Inc.'),
...

The code was not created by me. I am just investing some one else's code, this person is leaving us soon. I just want to make sure that the...

Have you checked it returns the same results?

You are thinking LEFT JOIN works like OUTER APPLY (it doesn't). You can rewrite the first query using OUTER APPLY instead of LEFT JOIN:

SELECT Grades.[Name] AS Grade,
...

I asked ChatGPT:

WITH RankedEmployees AS (
  SELECT
    employee_id,
    employee_name,
    department,
    joining_date,
   ...

This appears to be a classic "Next_ID" table and I find it difficult to understand why anyone would be using such a thing in this day and age, especially...

I would indent the query like this:

FROM CHG
LEFT JOIN CAMCHARG CC  
     LEFT JOIN CAMRULE CR    
  ...

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