Viewing 15 posts - 91 through 105 (of 2,917 total)
As a thought - any way you can reduce the database size? Is there some data you could archive to get it to a more manageable size or is all...
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.
August 6, 2025 at 7:42 pm
My opinion, AI is great for handing tasks that are slow and error-prone by users. Hand me a 1 GB log file and ask me to find the problem 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.
August 5, 2025 at 8:10 pm
if don't use linked server, how can I achieve my request ? could you kindly give me some suggestion? thanks!
One way to handle removing linked servers is to handle...
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.
August 5, 2025 at 4:28 pm
I'd start by following the Microsoft advice for troubleshooting this - https://learn.microsoft.com/en-us/troubleshoot/sql/tools/troubleshoot-database-mail-issues
If that doesn't help, then you may want to check your spam folder or outlook rules that may be...
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 31, 2025 at 10:02 pm
I do agree that in place is not the best way to go, but sometimes it is the best of a bad situation. The way my environment is set up,...
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 31, 2025 at 2:59 pm
Mistakes happen - it's how we learn. Plus, systems and/or processes and/or policies should be set up to minimize the chance of mistakes. If a big mistake happens, that means...
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 30, 2025 at 4:14 pm
My opinion, upgrading is pretty safe. If you are concerned, set the compatibility level to 170 150 to keep your databases working like 2019 and without any 2022 features.
I'm slowly...
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 30, 2025 at 2:35 pm
It sounds like a pretty big ask for a free forum to me, but my advice is you track whatever information you feel is relevant. There is data captured by...
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 29, 2025 at 7:18 pm
I give it -1 for suggesting a trigger. My rules with triggers is they can only be used if there is no other way. Put the stock update in...
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 29, 2025 at 7:06 pm
I'm sure there are a TON of these types of experiences. This and DBA's trying to fix issues that don't really exist. Pinal Dave had a good article recently about...
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 29, 2025 at 6:54 pm
It is still not working, I tried something similar, I think the issue is that @Period is an integer and @FiveYearAgo is not so if I do the where...
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 29, 2025 at 3:29 pm
That is always a fun thing to find and a fun thing to fix. Loops and row based logic are performance killers for SQL and unfortunately, I don't think any...
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 29, 2025 at 3:25 pm
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...
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 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....
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 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...
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 25, 2025 at 5:28 pm
Viewing 15 posts - 91 through 105 (of 2,917 total)