I don't really feel like I should be defending myself here, but 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P' is 57 characters long, the length of all those columns is...

You're welcome and thank you for the feedback.

It sounds to me like you have an identically named/structured table in multiple databases and they want to keep all of them in sync insofar as content.  Is that correct?

We can certainly prove that with the...

First of all, I appreciate it when anyone puts the time and effort into writing and publishing an article, so thank you very much for that.  Keep writing.

As you've seen...

HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide -...

HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide -...

This question isn't designed to cover all possibilities. Writing questions like that is hard and fraught with perils. You are welcome to submit your own questions about other types...

This is a tidy approach, but I'd have concerns, from an audit point of view, about data having been manipulated before it even hits the database. Potentially makes that...

HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide - one with...

Good basic question, Steve.  My only objection would be the title of the question itself because this also occurs for much larger numbers and larger VARCHARs.

Most people want to make indexed views for performance purposes which, of course, don't work on remote servers because of the schema binding issue.

If you don't really need it to...

@andrew Goffin-302397 ,

I realize the your post has been hijacked, so I'm still trying to get it back on track but I need that bit of info I've been asking...

BHWAAA-HAAAAAAA!!!! And... it doesn't use  curly braces. 😀

A...