Viewing 15 posts - 13,366 through 13,380 (of 59,063 total)
December 16, 2017 at 12:27 pm
I believe the answer will be that it takes less time and fewer resources to update X rows in a narrow table than it does to update the same X...
December 16, 2017 at 12:05 pm
@MMartin1
Oh boy! Sometimes these posts get lost with all the emails I get. I was reviewing this for other reasons and...
December 16, 2017 at 9:03 am
stevenmillward - Friday, December 15, 2017 10:37 AMHi thanks for all your comments, making some progress now
What does that actually mean?
December 15, 2017 at 7:38 pm
December 15, 2017 at 7:37 pm
December 15, 2017 at 4:28 pm
Even though stats are updated "every week", it could still be a stats problem. It could also be that the data finally reached a "tipping point" and caused code that...
December 15, 2017 at 10:07 am
sqlgrease - Friday, December 15, 2017 9:59 AMI tune for response time first and resource usage second for on premise.
Although there...
December 15, 2017 at 10:03 am
December 14, 2017 at 9:06 pm
December 14, 2017 at 11:06 am
Thanks all for valuable replies. I modified the query in this way:
SELECT ...
December 14, 2017 at 10:36 am
December 14, 2017 at 8:33 am
December 14, 2017 at 8:23 am
Viewing 15 posts - 13,366 through 13,380 (of 59,063 total)