While investigating this, we've realized that there are DNS issues where an A record for one of the nodes didn't exist. We manually created it but we're still having...

I'm also seeing this in the SQL Server Error Log:

A connection timeout has occurred while attempting to establish a connection to availability replica availability_replica_name with id availability_replica_id. Either a networking or...

I've not had to solve this sort of problem, but my initial thought is to have a reference table with currency types.  Use an IDENTITY INT column as the PK...

One of the SysAdmins ended up creating a new VM on the UCS with the latest VMWare tools that were still compatible with the old host, in case we ended...

Lynn, Sue.  We moved the guest VM back to the old host just as a test, and things have improved quite a bit.  PLE is recovering as well as the...

The other thing that changed is that suddenly during the 6am hour on 5/12 waiting for LCK_M_X starts becoming more prevalent on the 12th.  By Monday the 14th queries had...

Thanks Steve and Perry. 
I wish I could say that I've done a cluster migration but I've just never been in an environment using clusters until now.  I'll do...

Thanks. Other download pages I've been on showed all the options right there on the download page, so I missed that little link above the x64 options.

I looked at the error log on the Primary and saw an error indicating that the account running the SQL Server service  did not have CONNECT permission on the endpoint. ...

I looked at error log again an saw a repeating error of "There is no compatible encryption algorithm" and realized my previous T-SQL where I dropped and recreated the endpoint...

Thanks Perry.  Sorry Just replying.  That's what I was thinking we needed to do but because it was a physical to virtual situation I wasn't sure if there was more...

Phil, part of why I'm here asking the question is that the first query in my post identifies the indexes, but those indexes don't seem to be full text indexes. ...