Thanks so much, Steve — I really appreciate this.

I know you didn't have anything from that era yourself, but taking the extra step to post this to the MS MVP...

Thanks, Johan! I appreciate the response!

Jeff,

Thank you for the response and for the clarification. Also, I didn't realize that Eirikur had taken it even further! If I end up incorporating it into my code, I'll...

Fair enough, but what if I remove all of the comments beforehand, then employ my technique? Then it should handle your most recent examples AND be considered valid since it...

frederico,

Thank you for the response. Have you looked at my most recent proposed code? It doesn't use CHARINDEX, so I believe it works in all of your examples...

Hey all, I'm wondering if I can avoid using REPLACE at all (at least with spaces and/or CHAR(10) CHAR(13) so that we don't need to worry about potential JOIN predicate...

Scott,

Thanks for the response. Would you mind explaining your code a little bit?

I get the gist that you're replacing multiple spaces with one, but why the variance of #s in...

Brian,

Thank you for commenting! I hadn't thought about proactively REPLACE-ing CHAR 13 and 10 with a single space to simplify things and then also be able to use LTRIM and...

Correct. I have quite a few.

I would do...

As long as your cluster maintains quorum - the AG will continue to function and you won't have any issues, that is why you have the file share witness.

For...

Got it. Thanks for the response!

Grant,

Ya know--I was giving one your responses a little more thought...you stated that optimize for a value is a potential fix for Parameter Sniffing. I agree but wanted to get...

Honestly--yes. I think all of this. I knew already knew some of the potential fixes, but the information about CHAR(1), the histogram, etc. and how the optimizer will behave, while...

Hi Grant,

As always, thank you for the response. Just one thing, if you don't mind.

I understand how indexes work and the importance of the selectivity of the leading column of...

Thank you, Grant! That actually clears everything up. I wasn't planning on using RCSI at a connection level, but rather just trying to understand the different ways in which it...