Lets practice some relational stuff, now your sets are small

visualize what you are doing !

Moving the year selection to a view is going to...

I haven't experienced any issues just performing the upgrade on passive nodes.

The upgrade process handled it all very well.

Because you use "AND races.race_year = 2019" you turn your query result into the results of an inner join !!

add "or races.race_year is null" if you want the full results

 

BTW:...

It's always lovely to have numbers, dates , datetime info stored in (N)varchar as it guarantees for problems in the future.

Is there any chance you can just replace the '$'...

I haven't got a clue

because I don't like sequence numbers in column names ...

Declare @pvtColumns nvarchar(max) = ''
Select @pvtColumns= stuff(
   (
        ...

With the answers you provided, DRP = worst case, how much data do you think you will loose ? At least 24h !

and how long will it take to get...

1. Why only systemdbs once a week ??

You will lose a week of systems administration actions, sqlagent job information, ...

2. What kind of SQL instance is this? DWH / OLTP...

Depending on the databases data size, your best option is to script it all ( without collation )

As you noticed, you can alter a database default collation, but existing objects...

Following up on this, we gave up trying to pinpoint what query/queries were causing the issues.  Threw 64 GB of RAM at it which resolved the issue.  We spotted...

I'm sorry, I misinterpreted / half read your request.

As you noticed, in SQL2019 QS only stores individual query plans.

For stored procedures its tied by object_id.

Maybe this gets you started.

            
September 13, 2022 at 11:43 am
            
#4087024

            
            
                                                
        

/*

Get long query text from QueryStore 

*/
Select *
from sys.query_store_query
where query_id = 44068


SELECT QSQT.query_text_id, 
       QSQT.query_sql_text, 
     ...

School assignment I presume.

I don't use SSDT, but you can check it all at " Compare and Synchronize Data in One or More Tables with Data in a Reference Database "

do not allow for dynamic sql to be used.

Provide the needed stored procedures that accept all input parameters and only grant the application account execute authority for the sprocs.