The fundamental problem you're dealing with is that data required for relational joins is split across multiple servers. I'd suggest replicating or ETL copying the table [SchCalendarBasicSchedule] (and any other remote...

That's the type of question I'll typically ask, but I'm also flexible about what specific answer is acceptable. What I expect to get out of that is a five minute...

So my understanding is that you have this table containing millions of rows and a procedure which updates the following NULL-able columns, sometimes as often as 1,000 times per minute...

... Far too many of us look for jobs when we need them, often feeling financial pressures to accept the first offer we get. The pace of hiring usually prevents...

It seems that CosmosDB can do anything data, and do it all in the cloud. The Microsoft empire strikes back!

That AceText clipboard history tool sounds like a good place to keep common code blocks for things like error handling or DMV queries. Also, if you simply type the one or...

Yes, T.J. Maxx...

E-books do greatly expand the universe of reading material. However, after looking at PC displays all day long, I refer to read paper bound books at home, particularly non-technical books....

A free open-source tool called XML Notepad can be used to format or compare XML documents. Also, BIDS Helper's Smart Diff feature. The thing about compiled C# executables is that...

So in addition to querying 120 million rows and 300+ columns, the underlying tables are buried within views. This is like the worst ETL scenario possible... but every corporation has...