More testing and pieces coming, but the short answer is the computed column...

Find the places where the table is being updated. Those are likely vectors for SQL injection.

Perhaps this will help?

Public Shared Function StringToByteArray(ByVal hex As String) As Byte()

Dim NumberChars As Integer = hex.Length

Dim bytes(NumberChars / 2) As...

I did an RC0 upgrade. Glad I let it run in the background. It was rather slow.

Jeff Moden (3/11/2016)

@steve-2 Jones. This would be really good for an editorial especially if you included the links and encouraged folks to vote the fixes up. If you...

I tend to agree with g.britton. Python would have been a better choices, IMHO, for lots of the admin stuff. If they'd hooked this into the .NET namespaces and objects,...

Great other solutions.

It would be good to showcase a comparison of different methods at scale. I'll try to do one, using Jeff's test data piece to scale up test data...

Your tests shouldn't be processing that much data. Use test data that represents what you want to test, which should be a few documents.

This isn't really built for scale/performance testing.

Have you checked target server memory?

Glad it's working, but you should make sure the DAC works.

If you use SSMS and the ADMIN: trick, you likely need to be on the console of a node. Not...

I've used SSMS 2012 to connect. Just need to not allow the OE to connect and put ADMIN in the query connection dialog.

Glad it's working.

However, I'm not sure we'll ever get rid of "notes" fields.

*groan*

Data Driven, announcing SQL 2016, going on now: https://www.microsoft.com/en-us/server-cloud/data-driven.aspx