Not entirely sure, but I do know there is a proc that you can run, which might do what the auto cleanup is missing: sp_flush_CT_internal_table_on_demand

I might run that and...

No company can afford a highly skilled coder to go around refactoring their code base and shouldn't use an inexperienced coder for the task.  When does it make sense...

I am currently in the midst of a refactoring project primarilly intended to "quiet" the log files.  Non-catestrophic errors and warnings are polluting the log files causing unacceptable growth.

One...

I tend to adopt Aaron's view a lot. I am refactoring my code and trying to make it better, but also help me clean things up that are an investment...

You can ask the AI what they did. I asked to restore a single table. Got "RESTORE FROM DISK WITH SINGLE_TABLE". Told it didn't exist but I could have pasted...

This apply?

https://support.microsoft.com/hu-hu/topic/kb4538365-fix-change-tracking-cleanup-does-not-work-when-invalid-cleanup-and-hardened-cleanup-version-are-negative-in-sql-server-2017-and-2019-f186bd92-622c-89f2-a6c2-739c250593f2

Expired records should be those that are in the tables, but should be deleted. Are you saying based on settings there aren't any records in the on-disk table...

Jason,

ask yourself this. Is the vibe coding any different from blindly approving a PR from a colleague? Or having to support someone else's code who you know takes shortcuts?

Those lawyers...

There is an FTP task in SSIS (https://learn.microsoft.com/en-us/sql/integration-services/control-flow/ftp-task?view=sql-server-ver17) and it works. Not SFTP though.

Works fine and I ahve friend still running xfers via ftp (or sftp via third party)

Glad you liked it

Yes, indexing makes a huge difference and the performance savings can overwhelm the index creation time/CPU

I find that the more talented people are with a skill, the less they trust an AI or want to use it. It's interesting, because it "reasons" about as well...

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver17

I lean towards Uwe's solution, especially when I need the table to stay online and accept insert/update/delete while I'm deleting data.

Microsoft implemented a change requiring a cert that is trusted through the local hierarchy, or the client clicking "trust cert". Depending on which client versions were upgraded or servers changed,...

If this (MaxCatalogConnectionPoolSizePerProcess) is set to 0, then the client value is used. You might set this higher. Similar question (or yours)

https://learn.microsoft.com/en-us/answers/questions/5646615/catalog-max-connection-pool-size-100

I think you need more connections set up...