It doesn't actually matter.  Whether that possibility...

Let's stop an think about this... the backups didn't use to be a problem and moving to the new hardware is now causing a problem.  It could be anything from...

Awesome.  Thanks for the feedback.

While we are on the subject of 4 part names and consistency across environments, it reminds me of a DBA who I had the pleasure(!) of following three separate...

That's why we don't use server names as linked server names. We use names (like Reports) that can remain consistent regardless of the environments. EDIT: The linked server...

As some of the techs I work with would say, "Cool beans".  Thanks for the feedback on this.

As a bit of a sidebar, this is yet another proof that correct...

I don't think he was talking about using linked servers to update the AG jobs, logins and whatnot. I think he was about to go off on a...

Yes, I do understand how your hierarchy is setup and I understand that the ID column is just an integer.  What I'm saying is that it has not been included...

Great intro, Carlos.  Very much looking forward to the rest of this series especially since we've not used Query Store on our systems, yet.

Shifting gears a bit, a lot of...

I'm not groking what you need to do but it seems like you're going to have perpetual problems because you...

Ok... I guess the last question is how you uniquely identify the rows.  What are the columns and datatypes for what could be used as a PK?

Ok.  I don't have your "v_Manufac" view to test against but give this a try.

--===== Note that the following characters are replaced with an empty string if...

So each entry is on a separate line in the file?  And all lines...

I have no choice.  I can't - not allowed to store in a table. I have to use a text file 🙁 I have been trying LTRIM and no...

Considering the recent events on this site and the huge losses in functionality, you're preaching to the choir there.  😉   The impetus seems to have been...