I would only "grant" an RPO of 24 hours for DEV systems, and even then urge then to use full recovery and persue an RPO of max 1 hour.

Don't let...

"...There is no PRIMARY KEY on this table. Its a HEAP...."

The lack of a primary key does not make the table a heap. ( it is more a lack design...

yes, if it is causing page splits

( check clustered index, sort according to clustered index of possible )

You should be asking "why has this table 50% unused space" ?

• Is the free space on the data file(s) or in the log file ?
• Indexes can be...

SQL2022 is known to not being the fasted of the versions.

Have a look at Brent's blog Which Version of SQL Server Should You Use?

Have a look at Erins blog: Category: Statistics  

and Kimberlys blog about statistics

The evolution the product made over the years is still amazing me.

Even though, its current progress has less to do with the RDBMS engine itself.

I especially like the fact that...

That doesn't tell much, does it ?

Maybe the SQLSkills blog and refs can give you a clue for the reason you just have to wait until it finishes ...

SQLSkills...

DBCC Shrinkfile is indeed a slow operation !

Things that make it even worse:

• heaps
• (n)text / immage
• off row nvarchar(max) / varchar(max) / varbinary(max)

What's the result of this query ?

if you are using the Copy_Only parameter with your backup command, that should not be an issue.

In all other cases: Bingo

in your query you are using column [Int] instead of [Inte] !!

Indeed.

I'm now monitoring for XE qds.query_store_db_settings_changed

please follow:

How to post code problems

How to Post Performance Problems 

Can you post the ddl of your table tbl ?

Also keep in mind you may need to cast / convert columns to a varchar data type !

            
November 9, 2023 at 9:27 am
            
#4324337

            
            
                                                
        

My bad. I left some ambiguity in my question.

I'm talking about the primary database of a mirrored set, not about the recoverying version of it.

btw: In the mean time I...