Viewing 15 posts - 61 through 75 (of 2,917 total)
The EASIEST way to do it is to download and install a SQL monitoring solution that watches for database growth.
If that isn't an option, you'd need something in place 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.
September 17, 2025 at 8:07 pm
Just my 2 cents but the example provided in the link I provided to me proves that NKTg₂ is irrelevant in that example. If you assume NKTg₂ is 0, you...
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.
September 16, 2025 at 10:28 pm
My opinion - it is LIKELY related to the job not having access to the stored procedure, but the logs will be the best way to tell what went wrong.
If...
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.
September 16, 2025 at 5:37 pm
Check the job history. That'll probably tell you what's wrong. BUT as a guess, does your SQL Agent service account have permission to run that SP?
I would recommend changing 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.
September 11, 2025 at 4:31 pm
I'd also like to add that AI can also give bad advice. Before making ANY changes to the system, you should fully understand the advice being given. Like if 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.
September 11, 2025 at 4:27 pm
Lots of resources on dynamic SQL, but the basics of it are that you are storing your SQL TEXT in an NVARCHAR variable and then passing it to the stored...
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.
September 8, 2025 at 5:46 pm
My opinion - The first and second query are not going to be changing much, if at all as there is no logic in them, so duplicating them across 2...
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.
September 7, 2025 at 2:19 am
I would recommend you reach out to Plesk Obsidian. It could be that their installer changes the default config file for MySQL or possibly even passes the configuration straight through...
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.
September 5, 2025 at 4:23 pm
Sounds to me like you are using the wrong version of VS to work with that DTSX. I would try an older version of VS. I wouldn't try to upgrade...
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.
September 5, 2025 at 4:15 pm
Just to add to what MMartin1 said, branches are good to learn early on so you can try to avoid merge conflicts or code overwriting. Multiple people working on 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.
September 5, 2025 at 4:07 pm
I know you say to forget my first thought, but restrict access. Give them access to a test environment with close to live data so they can play around. 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.
September 5, 2025 at 4:02 pm
As a guess - did the person who installed SSMS install it using an admin account on the machine and install all of the components as "all user" not "current...
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 25, 2025 at 2:54 pm
A lot to unpack there, but to summarize git is included with VS, but there is no server associated with it. So all the git stuff would be local which...
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 22, 2025 at 5:58 pm
I would argue that by doing that you may be wasting space. For example, you said you have a 1 TB disk for TempDB, but if TempDB never goes over...
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 22, 2025 at 5:47 pm
As far as I am aware, there is no source control module for report builder. But that being said, there is no reason you need visual studio either. There area ...
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 22, 2025 at 2:50 pm
Viewing 15 posts - 61 through 75 (of 2,917 total)