Viewing 15 posts - 826 through 840 (of 59,078 total)
And I dont think its going to be fast with that many records - was really just hoping that there might be a faster way that I wasn't thinking...
January 4, 2024 at 6:59 pm
Jeff
the query is the slow part of a larger process.its not being posted to a screen - query is part of universe of claims process that needs to look...
January 4, 2024 at 6:57 pm
Hi Steve,
Thanks for getting back. I was given this table and figured out that this field a varchar(4000) was the field with the start and end dates times. I...
January 4, 2024 at 4:09 am
It returns over 22m records in about 5 minutes.
According to your query, you're returning 22 million rows to the screen...
Question: What makes you think that's going to be fast? ...
January 4, 2024 at 4:05 am
That's great but without the book, the uncommented code you posted doesn't explain at all what the code is supposed to be teaching.
January 4, 2024 at 3:54 am
A serious word of caution on the use of PAGE compression... If you're into doing any index maintenance, PAGE compression will nearly double the time and CPU it takes. You...
January 4, 2024 at 3:39 am
It's just a select from 3 tables, and 2 of them are with left join. For aggregations, I would have done it on SQL Server side. Now I...
December 30, 2023 at 12:29 am
Is your "report" going to return all 600 Thousand "records" or is it going do some form of aggregation?
December 29, 2023 at 2:44 am
Heh... AI being "confidently incorrect"... Imagine that. 😛
December 29, 2023 at 2:36 am
To repeat the question that Phil asked but in different words....
You say something would "return error". Please copy and post that error.
December 27, 2023 at 7:06 pm
The following will do it without anything "fancy" that might not work in Oracle, which I've almost totally forgotten about.
WITH
cteMinCustNbr AS
(--==== Calculate the minimum...
December 26, 2023 at 4:43 am
Why I was never popular with bosses:
Boss: Welcome to the shortest day of the year!
Me: Aren't all days 24 hours?
BWAAA-HAAA-HAAA!!! "IT DEPENDS".
December 23, 2023 at 9:31 pm
I actually just realised PIVOT isn't working when Multiple rows are present Putting a fake aggregation such as MAX isn't working as expected.
I'm stumped 🙁
Any ideas, to point me...
December 22, 2023 at 11:57 pm
Same to you and yours, Steve. And Merry Christmas to everyone. This is a well deserved 4 day weekend for me. Next weekend is, as well.
December 22, 2023 at 11:50 pm
Update. We migrated from 2016 Enterprise Edition to 2022 Enterprise Edition. Virtually everything is run 30-40% slower. I also did some simple tests between 2017 and 2022 on the same...
December 22, 2023 at 7:55 am
Viewing 15 posts - 826 through 840 (of 59,078 total)