Someone here imported a large text file using ADF, and all the fields ended up as nvarchar(max). I was livid. I don't think the person who did this even...

I find that a whole lot of people have some really serious problems with smaller data sets.  I been told probably hundreds of times that "performance doesn't matter because...

Couple of things come to mind about this:

I don't worry as much about big or small as I do about good or bad.

Size doesn't matter as long as we...

Thanks,  I don't use functions that much, so it caught me which is why I wrote this.

The question says AdventureWorks. This is a public schema.

I think you likely have a good team. I think most of Redgate grinds. However, in many other places I've worked, relatively few people grind away at their careers.

It's the well known AdventureWorks database. All tables have PKs in there.

Nah, that's just poor communication. Most people suffer from this, including me, which is why I think AI use is ultimately going to be limited.

I can. The post also contains this (link removed):

Please share your io games insights and knowledge about this.

io games was linked. Not sure if this is a signature or if this is...

I'll admit I was struggling a bit to wrap a question around ANY. Suggestions welcome.

Apologies for the duplicate answer. That doesn't affect the question, but I'll award back points and change it to something else (wrong).

AGs are amazing. Wasn't sure you could, so didn't suggest, but that's essentially log shipping things.

Glad you have a solution

Tight coupling is great job security, at least until your org can't compete anymore.

Hard to know what you're doing here, as we can't see config. In general, I wouldn't use replication here.

I'd backup and restore. Once you have a full starting to restore,...

Do you mean that you have 2 nodes and workloads running against both (different dbs on each)? Is this a WSFC?

First, you should copy the db(s) to another system running...