Viewing 15 posts - 121 through 135 (of 2,919 total)
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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....
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 9, 2025 at 2:08 pm
I think it really depends on how much the data is going to be changing. Where I work, the data changing in the database is slow. Some of our databases...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 8, 2025 at 7:22 pm
My opinion - Access is the wrong tool for the job. If you have a SQL Server standard (or higher) license, use SSRS for this instead. Report creator uploads the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 8, 2025 at 7:12 pm
First, I'll say I've not done this before, but wanted to give my opinion on how I'd approach this problem.
I'd say test it out. For issue 1, I'd use the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 7, 2025 at 3:43 pm
I know you already did this manually, but I'd recommend using something like Visual Studio/ADS (I think this is being retired)/VS Code and GitLab/GitHub. I recommend some self-hosted git so...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 7, 2025 at 3:06 pm
Do you need real-time data in the secondary database? If not, you could have an SSIS job that pulls data out of the primary and pushes it to the AI...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 4, 2025 at 6:56 pm
The other fun thing is MOST modern systems have audits of some sort. So even if you try to say it wasn't your fault or you pretend it wasn't or...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 4, 2025 at 6:02 pm
Viewing 15 posts - 121 through 135 (of 2,919 total)