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.

If these tables make the majority of data of that database, just restore the full database to a new database name and remove the ones you do not want to...

have you been able to intercept the long-running-blocking transaction ?

What is so "special" about it ?

have you checked ( and validated ) the "know issues" for CU16 ?

Validate the...

The biggest optimization I've done is to have its name meet our naming conventions ∇

 

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know...

Why upgrade to SQL2012? If possible, go for a supported version. Performance and management features have been enhanced very much!

Also double check the current db levels for all databases!

e.g. SQL2012...

in this example, I've oriented everything towards its end of month date.

When working with date/datetime, stay in that data type as long as possible because of validation and appropriate builtin...

during the setup process, the used accounts are being granted connect to the endpoint, so that is covered.

 

what have you tested for this homework assignment??