Also, how much data is time-sensitive.  In other words, how often does last month or last year data change.  If only "current" data is updating, you can partition the data,...

If you are looking for data for a full month or a full year, then use the start of that year(or month) to the start of the next year(or month). ...

Firstly, it is safer to use named parameters when calling a proc.  If somebody adds a new parameter between the existing ones, you have to go and find and edit...

Do you have a TOP(n) without an ORDER BY?

Is it always the same symbols that are static, and the same symbols that change?

With such a large query, I would start...

You cant use a variable here

ROWS BETWEEN @AVERAGE_LENGTH - 1 PRECEDING AND CURRENT ROW)

You can achieve what you are attempting by using Dynamic SQL

DECLARE...

This tweak seems to solve the issue

Select @requested_qty = CAST(@requested_qty as float) * (@conv_fact_nr /@conv_fact_dr)

Just ask copilot to look at all of the files in your solution and suggest potential performance improvements.

To be honest, I would not expect any useful feedback from a question...

Trying to optimize something just because is like trying to skate uphill into a blizzard.

As Brent Ozar keeps reminding us ... "What problem are you trying to solve?"

Every optimization comes...

Without data to test, maybe this will do the trick

SELECT    f.INVG_ID
        , MaxAgentSFRDt    ...

SSMS 21 allows you to integrate directly in to GIT.

It looks like a sophisticated plug for their company, with 2 links to their site

A clustered index may appear to retain the sort order.  However, there is zero guarantee that it will always be sorted correctly.

The ONLY way to guarantee sort order is to...

Agreed.  But now I am no longer getting email notifications on threads that I reply to.

Consider a table like this

CREATE TABLE dbo.MyTable (
    ID        int      NOT NULL...

Why add an IDENTITY?  You can use a SEQUENCE object, and set it as the default value for the field.  Then you dont need to change anything else.  You can...