Posting your solution would be very much appreciated.

did you check with Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency

indeed that setting reverses.

btw the errorlog file is so polluted with SQLMI loggings of backups etc, and are not persisted over failovers

Have a look at my little article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Thank you for the feedback!

and kick the designer in a place where it hurts ...

It is a best practice to follow up on SP & CU for your sqlserver version. Especially inspect for issues you experience.

Here's a prep list I found on one of...

The biggest down side of an in-place upgrade is that is keeps things working, hence it may leave fixed issues open to keep it working with the settings of SQL2008.

That...

I would make sure to have my  SQL2019 upgraded to one of the most recent CU's !

Microsoft SQL Server 2019 Builds

have a look at CharIndex

/* from https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql */
DECLARE @document VARCHAR(64);  
SELECT @document = 'Reflectors are vital safety' +  
    ...

What queries have you tried out yourself?

well ... actually ... a couple of months ago I got my IoT thermostat (Netatmo) because it regulates my temperature way better than me due to its learning mode.

However, I...

Lordy.  I understand...

aaaand .... you missed the most important message !

You may have fixed this little issue, but you are still using a...

Why do you want to use a cursor to do this.

Think SET !

you are using 3part naming to address the new matchcode object, remove "USE [test]" before statement INSERT INTO...

• This reply was modified 4 years, 1 months ago by Johan Bijnens.