Probably I was not clear- I am not going to restore any backup from 2016 to 2014. Question is about creating cluster with instances with different versions, i.e. adding to...

Just curious- if we run same query (let say we have this option) on sql server directly (via SSMS) and won't have any issues- does it prove this (issue) is...

Thanks Jeff,

Will do shortly- have Prod issue right now 🙁

Accidentally pressed Post tab, sorry 🙂

Anyhow, thanks for all suggestions- I'll try to tune Update statement myself first.

You mean it can be (let say, potentially) bad query itself? I know it's not the best and we have some ideas how to improve it but even did not...

No blocking- checked. For some reason this process (as per sys.sysprocesses) has SOS_SCHEDULER_YEILD wait, i.e. allows other processes to use scheduler thread (but waiting itself). May be this wait is...

Google "partition sliding window" and you will find answers for all your question 🙂

Hmm,

But in accordance with MS blog:

https://blogs.msdn.microsoft.com/psssql/2008/04/10/how-it-works-file-streams-requires-integrated-security-windows-authentication/

"File Streams only support integrated security access. The Windows HANDLE model does not understand SQL Server logins"

Am I missing anything...

Thanks Perry.

On the second thought- this problem (2-nd instance should follow 1-st one after failover to another node) looks a bit confusing to me now. I mean main reason for...

Not sure what can be wrong from 3 options you listed: 1) cluster instance name I know for sure as have connection (from SSMS) opened in front of me; 2)...

As we figured out (and MS confirmed this) when "initial encryption scan" was aborted decryption stopped- not canceled, not rolled back, but stopped

(as per MS there is bit - sorry,...

Thanks

Thanks Scott.

To resume (if I got you)- I should use Start of new Instance event to catch failover (or other words, both instances running on the same node)? Actually I...

I am afraid it's not an IP issue- as I mentioned connection via IP works for sql server account (i.e. IP is correct). I mean I created test sql...

Thanks Perry- seems from external User point of view DB will be online all the time. This is good. But frankly I am still not sure how data from...