During those periods where readers appear to be blocked, have you run sp_who2 to confirm blocked spids?

I use Siri sometimes in the car, but it's only helpful only when I can get a specific answer to a question like: "Siri, where is the nearest gas station?",...

 I've seen some interesting interactions with Slack, including one company that allows limited developer access to systems through a Slack bot that handles some provisioning work, including raising and closing...

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...