Viewing 15 posts - 1,411 through 1,425 (of 22,202 total)
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...
February 12, 2021 at 1:17 pm
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...
February 12, 2021 at 1:14 pm
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...
February 12, 2021 at 1:12 pm
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...
February 11, 2021 at 2:32 pm
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...
February 11, 2021 at 2:09 pm
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,...
February 11, 2021 at 2:05 pm
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...
February 11, 2021 at 2:00 pm
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.
February 10, 2021 at 3:31 pm
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.
February 10, 2021 at 2:03 pm
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...
February 10, 2021 at 12:31 pm
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...
February 10, 2021 at 12:28 pm
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...
February 10, 2021 at 12:25 pm
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...
February 10, 2021 at 12:13 pm
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,...
February 9, 2021 at 12:13 pm
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....
February 9, 2021 at 12:03 pm
Viewing 15 posts - 1,411 through 1,425 (of 22,202 total)