SQL linked servers is getting more and more popular because data can (and does) exist everywhere, users naturally want to write one query that joins as much data as possible with no regard if it is ...

I have a table on my local server that has customerIDs, I am linked to a remote server that has customer address data by customerID. I want to return matching addresses for all the customerIDs that I ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...