Viewing 15 posts - 46 through 60 (of 2,853 total)
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
Possibly a dumb question, but what version of SSIS was your package targeting?
This is in the SQL Server 2019 section of the forum, so I suspect it is SQL Server...
July 22, 2025 at 2:31 pm
I half-second Perry Whittle's suggestion. I personally don't like maintenance plans as they don't scale well. You spin up a new instance, you have to re-deploy the maintenance plan. Change...
July 22, 2025 at 2:28 pm
I have not used replication before, but quick google brought me to this:
So, I think it depends on where the latency is. Is it between publisher and distributor or distributor...
July 21, 2025 at 10:28 pm
Thanks a bunch Jo!
I'm going to check what mine are set to. I suspect they are either default (likely) or high (for no good reason) and I'd like to bump...
July 21, 2025 at 10:19 pm
Just wanted to add my 2 cents to this. I know this isn't a "new" topic (created back in Feb), but I wanted to play devil's advocate a little bit.
My...
July 16, 2025 at 3:19 pm
Maybe I'm being pedantic, but I've never heard of a primary key index. As far as I know, you can make a table with a primary key that...
July 11, 2025 at 8:50 pm
I would get some git system. Downloading and storing files on disk is not a good long term solution for source control. GitLab (for example) has a free tier that...
July 11, 2025 at 8:49 pm
I think that is expected behavior. Naming a computer with a \ is not a supported configuration in Windows (server or desktop). BUT I think that isn't quite what is...
July 11, 2025 at 7:53 pm
I'm really good at starting personal projects... finishing them is a different matter though. I have so many little projects on the go that I need to finish one day....
July 9, 2025 at 4:11 pm
Maybe I'm being pedantic, but I've never heard of a primary key index. As far as I know, you can make a table with a primary key that is a...
July 9, 2025 at 2:08 pm
Viewing 15 posts - 46 through 60 (of 2,853 total)