Just get a bigger truck may get this thing done $$$$

Did you validate and test other options for your single table ( 476GB ) ?

How much of that data is...

Your subquery does not make sense as it is not related to the from clause of your query.

(and because it performs the same query as your from clause, it will...

Just to be clear: A tail log serves the target database at the target server of your restore.  ( so in case you need to restore that one back to...

Do not perform a Tail log backup if you just need a transaction log backup !!

A tail-log backups only purpose is that you can restore the original database as it...

Did you actually prefix the correct master database ?

In that case you might as well perform a "union all"

/* contained AG master db */
SELECT 'AG1_master' SourceMaster, *...

So you connect to one of the nodes of the Windows cluster hosting the Contained AG ?

( I don't know if access to master db is blocked when connecting to...

• This reply was modified 11 months ago by Johan Bijnens.

Enable "auto close" for that database and monitor the sql server errorlog to see when it is being brought online.

ALTER DATABASE [Yourdb] SET AUTO_CLOSE ON WITH NO_WAIT...

I first prepared both stand alone instances.

Then I restored the needed db on one instance, configured the needed sql accounts ( using dbatools Copy-DbaUser ) and sqlagent jobs (...

1. Your database needs to reside in a non-simple recovery model. ( preferable full recovery model )

   You need at least create one FULL backup ( to actually activate the log...

did you try casting "value" to a numerical data type ?

e.g.

...
SUM(CASE WHEN [Metric] IN (...)
THEN cast([Value] as decimal(18,2)) END) AS [...],
...

Launch a profiler trace to see what is going on

FWIW :

Scientists are currently busy recreating tissues or animals that have been extinct for millions of years.

Perhaps that will be the fate for relational DBA and this phase will occur...

We're not dinosaurs!  I saw a Star Trek movie (from the 23rd century mind you) where Spock said that a SQL injection attack was used to do nefarious stuff. ...

FWIW

This is the sql script I always use to detangle my wait resource:

(as the script serves me for ages by now, the originatin utl's no longer work )

            
October 17, 2024 at 9:33 am
            
#4469497

            
            
                                                
        

waitresource="PAGE: 14:1:5803256 "

Blocking spid="298"

Blocked spid="93"

use SP_WHO2 to figure out these connections