The source code for the function is proprietary, and thus, unavailable. The number of rows it would apply to would be relatively small. As the only...

The issue has been resolved. We found that one of the core assumptions the rules were based on was not actually true. Table data was...

I don't get to use trans often, so I missed that part, but ultimately, that wasn't where some of the problem turned out to be. I had...

Unfortunately, that fails to produce a change in behavior. Has anyone heard of Sophos anti-virus causing depth of process call to fail without any errors getting triggered in...

I know the substitution works correctly because we have that working on ALL the rules, so I know it can't be failing here unless something to do with nested EXECUTE...

That was why I tried just replacing the one rules' logic SQL to execute a different proc that just does a lot less. Clearly, the rule is getting...

I'll be...

Every once in a while, I get lucky... and while it's almost always easier to be lucky than good, I try rather hard not to depend on luck...

It might be interesting to note if there is a behavior change if the source query were to be encapsulated by virtue of creating either a VIEW or a STORED...

@Grant,

That's really interesting behavior, and quite an improvement in the optimizer. Although, I wonder if, having figured out that SQL 2014 will start to allow you to "get...

Have you tried using nvarchar(max) to see if it is also affected? Somehow, I get the strange feeling that the other collations are resulting in interpreting what is...

Just curious, but could DNS help solve this? I don't know enough to know how, so I'm just wondering if someone else might be able to suggest a...

Thanks! I just kept not looking in the right place. Now that I have, it appears under the "Cross Box Scale Limits" that this limit...

I'm not so sure... As the variable is a constant, there is only one evaluation of it, and the value remains a constant for every record in the...

I have been unable to find a 64GB limitation in the specs for SQL Server 2012... Can you point me to a web link to that information? ...