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...

Let's be really clear, SSD are indeed, insanely fast.

If you put everything onto one SSD can you overwhelm it, despite it being insanely fast?

Yes.

There's a reason organizations like Pure Storage...

Extremely important thing to remember:

A common table expression (CTE) is not a table. It is an expression. A query. It does not, in any way, represent data storage, temporary or...

Well, defining stuff like this as "normal" is probably not the best way to describe it. However, is something like this expected? Yeah.

One of the hardest things is recovery from...

I'm not going to try to unpack all of that.

The optimizer thinks that the filter on  C_MT_B_COMM_TO_PTY.PARTY_TYP_CD + ':' = 'Contact' + ':' is going to do a lot more...

I don't believe the load balancing aspect, at all.

Yes, you can move some queries offline. However, that is not load balancing. Load balancing is the automated process of distributing where...

Or get the older version. Forgot to mention that.

You sure you got the question right? Looking through that list I can only see one thing that IS a benefit. Replication does not load balance. Replication doesn't distribute queries....