This won't work with GETDATE() because of the included time.  You either need to convert getdate()...

Start with the original source system - either implement daily full backups with frequent transaction log backups, or switch the database recovery model to simple and only schedule...

Start with the original source system - either implement daily full backups with frequent transaction log backups, or switch the database recovery model to simple and only schedule daily full...

Lookup Levenshtein Distance:

https://www.red-gate.com/simple-talk/blogs/string-comparisons-in-sql-edit-distance-and-the-levenshtein-algorithm/

https://www.kodyaz.com/articles/fuzzy-string-matching-using-levenshtein-distance-sql-server.aspx

That is unusual - is there anything specific about that one node that is different than the other servers?  I would check the default DNS settings for the server and...

Not sure I understand the issue - have you removed the user from all databases on the primary (both databases in the AG and those not in the AG) and...

The advice I have seen is to put the AG into Async mode for the duration of the patching, so that work can continue on the primary while you...

The simple outline is:

1. Patch and restart the secondary

   1. Wait for secondary to fully synchronize after restart

2. Failover from primary to secondary
3. Patch and restart primary

   1. Wait for full synchronization...

You are trying to use 4-part naming to reference the column.  That isn't allowed - you need to define an alias for the table and use that alias to reference...

Is there a way to create this output without using insert into and declaring anything.

Lets forget all the conditions. Lets just say that I need to print this without...

One of my suggestions in one of the many other threads you have created on this subject was to fix the data.  You can write all the code you want...

• This reply was modified 2 years, 12 months ago by Jeffrey Williams.

I am going to take a guess here - the OP is confusing the host with a guest OS either in Hyper-V or VMWare.  That is the only way I...

Thank you for posting the code - I believe the problem you have is going to be the estimation of rows for the table-valued parameter.  You can try modifying the...

I know this is an old post but wouldn't you want to patch the async secondary availability replica first like Ant-Green suggested? That primary replica regardless of which node...

So basically - keep it at 8 or lower unless you can specifically identify a scenario...