Viewing 15 posts - 46 through 60 (of 2,863 total)
I'd also like to add if rn, is_processed, and processed are all frequently used, I'd remove the "magic code" and persist those values to disk; even if they are calculated...
July 28, 2025 at 9:52 pm
As always with AI, you'll have to validate and test this all.
Mostly no rocket science, but applied guidelines as they should.
It will get better over time ...
I second this....
July 28, 2025 at 2:24 pm
So much out there relies on video and audio. As a deaf person, this is a whole world I struggle to interact with.
As an experiment, turn the sound...
July 25, 2025 at 5:28 pm
Hi Brian; thanks for the response.
Unfortunately, the [rn] is a pseudo-column from the ROW_NUMBER() window function so I'd have to store the output into a temporary table in order...
July 25, 2025 at 5:21 pm
As a random guess - I'd say your CSV has some invalid data in it such as a row with an extra/missing comma. This can happen when your CSV allows...
July 25, 2025 at 4:11 pm
As far as I am aware, there is no way to update a record AND select in a single query, but you could do it all in one transaction or...
July 25, 2025 at 2:48 pm
Thanks Phil for sharing the alternative to do. I never used VS database project for schema comparison. The idea of creating such script came as there was a requirement...
July 24, 2025 at 2:48 pm
Why would I need enterprise grade for a one man show? For something he'd run every few weeks? I'm not processing 100K files an hour.
If you can point out...
July 24, 2025 at 2:42 pm
That is very strange... If you have a diff tool (such as winmerge), it may help you look at the DTSX and/or DTPROJ files and try to figure out what's...
July 24, 2025 at 2:28 pm
How about doing it a little differently and instead of:
where @Period < (select LEFT(CONVERT(varchar(6),DATEADD(yyyy,-5, getdate()),112),6))
you first store the yyyymm in a variable with something like:
July 23, 2025 at 4:41 pm
I'd also like to point out that you should be careful with transactions that change large amounts of data OR are long running - if a query runs for 5...
July 23, 2025 at 4:35 pm
Glad that wasn't a dumb question. I know with SSMS I've hit snags when my SSMS version doesn't match the SSIS version and it will happily push the dtsx to...
July 23, 2025 at 3:33 pm
How many transactions are waiting to distribute and how fast is the distributer distributing them?
And did you read the article I linked? If you scroll down to the section "Improving...
July 23, 2025 at 3:16 pm
is that 20 minute latency from publisher to distributor or distributor to subscriber?
If it is publisher to distributor, then how many transactions are waiting to distribute and how fast is...
July 22, 2025 at 10:17 pm
Oof... I would almost bet real money it was set to default... BUT glad I didn't - it is set to 7 days. That makes me feel better.
Now I just...
July 22, 2025 at 2:36 pm
Viewing 15 posts - 46 through 60 (of 2,863 total)