Literally no way to really answer this question for you. Scale depends on so many different factors.

Let's look at it like this. The various different data management systems that are...

More data. "Something is slow and here are a bunch of wait stats" doesn't tell us anything. I'd suggest enabling Query Store on the database in question. It's relatively lightweight...

First, not trace. Use Extended Events. It puts far, far less of a load on the system. Plus, you're on SQL Server 2017. Every single piece of new functionality is...

Weeks? You're doing it wrong. You should be able to...

You can absolutely create logins (and there are several choices on how to do this) that only have enough privileges to do certain things and not others. And then, yeah,...

Can a column contain more than one data type? The short answer is no, unless the column is of data type variant. I do not recommend using this. I...

Microsoft has some fantastic documentation on exactly how to get your backups done in Azure VMs. Pretty much everything you need. Don't forget though, untested backups are unknown. The...

You mean a computed column? Probably not the greatest of choices, but yes. As long as it's unique and the...

I had to check, and yep, mainstream support ended in 2019. Extended support ends in less than two years. Don't "upgrade" to 2014. Move on to one of the three...

Strong, strong suggestion, if you're upgrading from 2000, 2008, 2012, skip 2014. Go to 2016 or greater. The reason is simple. 2014 introduced a new cardinality estimation (CE) engine, but...

Except for columnstore indexes, every test I've ever seen says reorganize is a waste of time. You may still hit timeouts doing a rebuild, but yeah, I'd stop doing the...

I would recommend that you work with the business to identify the columns that make a unique row. They have to exist, otherwise how would you differentiate between two rows?...

Glad you got it working.

This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'

That kind of wild card search can't make use of...

Congrats, Jeff. Quite an achievement. I used to try and keep ahead, but haven't bothered.

Now I wonder where I get to 1mm first. Here or in miles flown. At...

Glad you got it working.

This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'

That kind of wild card search can't make use of statistics and...