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

At the most fundamental level, access to data & structures within a database, there are zero differences between a SQL login and a Windows login. You will map logins to...

Yes, I work for them. Doesn't mean I'm not right.

SSMS Intellisense is weak, at best. Check out Redgate SQL Prompt. Not just wildly superior Intellisense, but code formatting, refactoring,...

Some combination of Extended Events, Change Data Capture and SQL Audit are what you're looking for. One thing to note, Change Data Capture modifies the data structure....

OK, I'm a little confused by how the question is phrased. It sounds like you & the security team are hesitant to use Windows Authentication? Don't be. Use it. It's...

Overall, SQL Sever 2019 is a radically improved product over, pretty much all of them. Just using Query Store as an example, it was great in 2016 and I fell...

I agree with Johan, 2019 would be the way to go.

Just understand one thing though, going from 2008/R2/2012, you are hopping a bit of a gap at SQL Server 2014....

I've no idea what Brent had to say. Great guy, but he wasn't on the board or directly involved. I've no idea what cloud stuff is being referenced. No "cloud...

Yeah. You could. The search results will stay in one window and you can open the queries in another. However, this is the slow, tedious, error prone way to get...

And when those I/O operations take that long, the problem is not inside SQL Server. It's outside. The OS, disk controllers, network, switches, hubs, or the disks themselves. That's why...

This. So very much, this.

Redgate has a free tool that can assist you searching inside your...