No arguments here. Just as many business are hybrid when it comes to the cloud, many are hosting multiple data platforms. I've been learning (relearning to a degree) some Oracle...

Call me anything you want, just not late for dinner.

The job of administering databases was radically different in 1995 than it is today. Technology has shifted radically.

Yet, there's still a...

You can set up Availability Groups and other HA solutions using Azure (or AWS, GCP) as the secondary. I haven't had to do it myself in years & years, so...

When they say "pages" are they actually thinking about something like a Yabingle search result? Get the first 25 "pages" could mean the first set of results and the last...

You're looking at it. SQL Server Central has simply tons and tons of articles and instructions on how to work with SQL Server. I'd suggest the Stairways series as a...

Troubleshooting query performance is an enormous topic. In fact, if you look down in my signature line, I have two books on it. One is nearly 1,000 pages long. The...

Anyone still running SQL Server 2000 deserves every bit of pain they get doing an upgrade on a 21 year old piece of software.

Yeah, I'm a bad person. I'm strangely...

Without seeing both plans and the code, I can only make a guess as to why you're not seeing the plan in cache. It could be, production is busy and...

I don't know what changes were made to DBCC between 08 and 16. I'm sure there were more than a few since there were all sorts of underlying updates. However,...

I don't recall it being a strict "two versions". Just that, at some point, they stop trying to keep the code up to date for the upgrades, forcing a two-hop...

Again, best guess, the openquery is running somewhere other than where you're running it locally. I've tested your code. It's working. I don't have any magic to add. It worked.

I don't know. I tested your code and it worked. I'm not sure what's going wrong on your end, but that's my best guess.

Wow.

So, the issue is not the OR clause. The issue is performing the ISNULL function on every single column as part of your JOIN. That optimizer has no choice but...

Without the code, structures, execution plans, I can only make vague suggestions.

Sounds like we're moving a lot of data around that could simply be filtered within a query. That's not...

Is it possible that you're running the SELECT statement from a different database than the one where you're executing the query through OPENROWSET? I just ran the procedures and everything...