It's a thrilling topic of discussion. I think it comes down to:

- Are you satisfied doing what you're doing now?

- Is there a current or future need to change it...

I admit this is one of my weak points, but read this: http://sqltouch.blogspot.com/2013/05/ansinulls-joinwhere-and-query-optimizer.html

While ANSI_NULL wouldn't directly cause deadlocks it does change the performance of a system to create...

I subscribed to the thread so post again if you find out more.

Instead of restarting the agent, you could try have a job to trigger on failover on both...

I understood the logic but not why = wasn't traditionally aliased to Is.

However from what both of you have said it seems a) there is a performance benefit and...

Are you sure? The MK is signed by the SMK. If the service account changed SMK changed through services.msc incorrectly then the MK could not be decrypted automatically and so...

No but if you do a search they have a t-e-r-r-i-b-l-e reputation.

It is probably referring to storing them encypted and incomplete form, nothing to do with left and right functions.

Thanks for the update, I haven't checked the WMI query yet but yeah it turns out I was wrong. The machines at work have the same problem and I just...

Did anything come of this? Weirdly I just hit it on my test lab today, even though at work in production I have a raw 2014 server that connects fine...

Yes the graphs are definitely the same. I mean it's not the same row/page but they're all on the same table, same queries, same combination of indexes.

The deadlocks being reproduced in replay appear to be the same as the ones from production. So I suspect in that case then it's okay to proceed.

The issue with...

Have seen it but not done it. There is a script you need to put on your jobs to make sure they execute on the right node and to re-encrypt...

Reviving a dead thread because it's late at night and I'm waiting for SSIS to finish running. For me the difference between SQL Developer, Architect 1, DBA, and Architect 2...

Your first scenario is one where you make others do their job and the groundwork to establish that there is some kind of connection or speed issue related to the...

The reason I thought not is because I was not aware of any long-running transactions on that database, I thought it's a data dump for single-row inserts with a fairly...