-- Find the first non-empty partition ready for switch

SELECT @firstpartition = MIN(p.partition_number)

FROM sys.partitions p

JOIN sys.tables t ON t.object_id = p.object_id

WHERE t.name = 'table_name'

AND p.rows > 0;

--Switch

SET @CMD = N'ALTER TABLE...

Does it has to be Certification only? Can you use it in some other training? If it is for your education

Take a look at Adam Machanic  sP-whosisactive will show who is doing what (save it to table)

http://whoisactive.com/downloads/

have you tried this,

SELECT name, log_reuse_wait_desc

FROM sys.DATABASES

Take a look at Columnstore indexes (https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-ver15)

Get well soon and send those puzzles of yours!!

Replication will allow you to go only two version UP or DOWN

https://blogs.msdn.microsoft.com/repltalk/2016/08/12/suppported-sql-server-versions-in-replication-topology/

You can use this as an alternative, DBCC CheckDB PHYSICAL_ONLY; it is a limited check but doesn't use that much TempDb

 

Check BrentOzar (First Responder Kit) and Adam Mechanic (SpWho2Active) tools, you can run those and save the result to tables that will give you some idea

To be more specific you can change the properties of the replicated object,

Open replication in SSMS and select Properties and select Articles and will bring you to this

 

August 8, 2019 at 11:49 am

#3669823

To be exact to what Micheal mentioned you can use Test-DbaLastBackup it has all the requirements you specified

Check this out

https://logicalread.com/sql-server-memory-buffer-pools-pd01/#.XPkC04hKgdU

dbatools could help too

I also missed the question posted by users it was well organized

You can have temporary relief if you want by creating an agent  job 
1. find out the max_elapsed_time when you have bad performance --- X
2. just write a simple...