Well, try to run your query by parts and check time taken

However, i'm not sure how this part of the query works ...

 AND RS_INTRASTAT_TAX_EXT.INTRASTAT_FLAG = case...

There can be many reasons why your query runs slower for a month period (parameter sniffing, outdated stats, blocking, etc).

I suspect that main issue here is different execution plans for...

if you run the following query you will see that the option is dynamic (see is_dynamic column)

select * from sys.configurations where name = 'max degree of parallelism'

It...

such script should take into account that the existing user can have additional rights/restrictions being a member of AD groups which also have access to the SQL server and appropriate...

I would check "instead of insert" trigger  and modify card numbers there

https://blog.sqlauthority.com/2013/01/24/sql-server-use-instead-trigger/

OR

check if Dynamic Data Masking is suitable solution

https://www.sqlshack.com/using-dynamic-data-masking-in-sql-server-2016-to-protect-sensitive-data/

Also, you can implement compression (page or row) and get indexes smaller + less I/O and wiser RAM usage.

Thanks to Kalen Delaney for the ported version of standard proc :

why if I script out and recreate the table as a new table, and then insert the same data into it, why doesn't the clustered index on that...

it's easily googleable

https://docs.microsoft.com/en-us/powershell/module/failoverclusters/Move-ClusterGroup

I would also rebuild existing stats

https://support.microsoft.com/en-us/help/974006/sql-server-query-optimizer-hotfix-trace-flag-4199-servicing-model

Quote:

In SQL Server 2016, trace flag 4199 hotfixes that are made to previous releases of SQL Server will become enabled under database COMPATIBILITY_LEVEL 130 without trace flag 4199 enabled....

you can use the following:

• sys.dm_sql_referencing_entities
• sys.sql_expression_dependencies
• sp_depends

But take into account that there's a deferred name resolution and the objects referenced within a stored procedure do not have to exist...

Also, useful queries :

https://stevestedman.com/2016/01/ssrs-report-usage-queries/

ReportServer database has ExecutionLog view which contain execution history of...

This table...

Edward hi!

thanks for sharing the alert, but there are couple of thoughts:

1) the following two selects can be written in one statement

Select @workers_waitingForCPU = sum(runnable_tasks_count) from sys.dm_os_Schedulers...