Viewing 15 posts - 1,516 through 1,530 (of 22,202 total)
For some reason (perhaps someone clicked on report instead of reply by accident), my previous post was reported as spam, so trying again...
Saw that. Fixed it.
November 5, 2020 at 1:14 pm
I'd say that REORGANIZE is unlikely to because it touches so few pages normally when it changes indexes. A REBUILD on the other hand, that might do it. I only...
November 5, 2020 at 1:13 pm
November 4, 2020 at 1:49 pm
The only real way to improve "move all the data, all at once, right now" style queries is spending money. Buy bigger, better, faster, more hardware. That's the answer. Or,...
October 30, 2020 at 11:51 am
So, let's be clear up front, I work for Redgate Software and we make a tool that competes with Foglight, so you can take that into account with what I'm...
October 30, 2020 at 11:50 am
Run DBCC checks on your system databases. It sounds like either one of them is corrupt, or you're hitting an issue with tempdb, as was suggested in the error message...
October 30, 2020 at 11:33 am
Also, look for hidden issues like triggers.
You can look at execution plans for INSERT/UPDATE/DELETE queries, same as for a SELECT query. Common issues affecting performance can include stuff like foreign...
October 30, 2020 at 11:31 am
I'm not that familiar with MySQL, so I can't say how it works. However, I can talk to SQL Server. The key here is that first column. There are two...
October 30, 2020 at 11:10 am
The statistics went out of date and need to be updated. As was already stated, the data changed, the statistics changed, a new threshold was reached, and when the plan...
October 29, 2020 at 1:40 pm
Total agreement with Jeff & Brian.
I will say though, to a degree, and there are hundreds of caveats to this, what makes a good index in one RDBMS, roughly translates...
October 29, 2020 at 1:36 pm
Just and idea for the future. To be helpful to others, go ahead and leave the question up, but supply the answer too. That way, the next person who hits...
October 29, 2020 at 1:33 pm
Is this person in way over their head? It seems like he was dumped in a closet and given orders to find out everything. He's been pretty prolific with...
October 29, 2020 at 1:13 pm
All you can do with the information you have is infer the schedule and plan. That's it. You can't know what the intent is. You can't know what the Service...
October 29, 2020 at 1:11 pm
You're approaching it all in the perfect manner. 1) find solutions to the problems at hand 2) use those solutions as a way to improve your skills.
Keep going. Don't hesitate...
October 28, 2020 at 7:12 pm
Oh, and if you have specific questions for follow up, don't hesitate to open another thread if necessary. More people will see the question that way. However, as much as...
October 28, 2020 at 1:42 pm
Viewing 15 posts - 1,516 through 1,530 (of 22,202 total)