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

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