Viewing 15 posts - 811 through 825 (of 59,066 total)
Phil Parkin will tell you that I'm not a big fan of SSIS or most of the any other 4 letter words in SQL Server.
That not withstanding and with the...
January 15, 2024 at 4:10 pm
Rule number 1: Claims of efficiency and/or performance MUST be accompanied by demonstrable code to prove it.
January 11, 2024 at 12:51 am
Third, the clustered index does store data in physical order on pages. The pagse/extents could get out of order, which is fragmentation, but that doesn't change the physical nature...
January 8, 2024 at 8:22 pm
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
Viewing 15 posts - 811 through 825 (of 59,066 total)