To start with, you will test this all out in Dev, yes? This will give you the process to use for Production.

For an AG, all servers in the AG need...

Without knowing what happened, it does smell a bit like locking.

Before retirement I made fairly extensive use of columnstore indexes, but I also had snapshot isolation active. SI did a...

• This reply was modified 13 hours, 49 minutes ago by  EdVassie.
• This reply was modified 13 hours, 48 minutes ago by  EdVassie.

What you are asking for is why I developed SQL FineBuild. If you want it can automatically set up SQL Server 2019 on a cluster complete with AG and distributed...

The long term solution is to move away from that application. It is unlikely you will be able to do this on your own.  A business case will need to...

Did the folder actually get created, is it only the error message that is wrong.

NTFS it's own database. It has an object store and a cache of Objects in the...

I would say that Oracle is no harder to learn than any dialect of any language. In other words you should learn enough on day one to say hello, but...

Schrödinger's Degree. Both needed and not needed.

Back in the day when I was leading development teams my experience was that people with degrees covered the same range of useless through...

Have you tried the "DB2 Connect" product from IBM. It is designed to get the best performance from DB2, unlink MS products where the vendor gains mo benefit from getting...

Regarding Fill Factor, you need to think through what is happening when this is applied.

Assume a FF of 10%, this means that after a rebuild every page, every page, will...

Speaking from the viewpoint of spending my entire career in IT and now retired, I totally agree with Steve.

Sometimes the new shiny can give a significant advantage to IT. Sometimes....

Grant is right about the benefits of having interests outside of work and family.  I am a member of the Tadley Men's Shed, and enjoy a lot of the things...

Most requests to restore Prod to Dev are due to the dev folk not wanting to build adequate test data. Doing this is costly, it takes time to think through...

I would second what frederico says. You should be doing this type of thing outside SQL server.

Be aware that the response from PING can be very variable and hard to...

Totally make sure the AG is fully synchronised before rebooting the second server.

If the AG is not synchronised then you get to choose which version of the DB you want...

I would go with Jeffrey Williams answer.

If you use backup/restore as part of your resyncronisation strategy then you must apply all transaction log backups taken since your original backup when...