Viewing 15 posts - 571 through 585 (of 2,917 total)
One thing before asking for faster disks - I would check if the disks are the bottleneck. I wouldn't try to fix a problem that doesn't exist.
Also, if the 200...
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 24, 2023 at 3:39 pm
That could be the case Phil, but it also doesn't hurt to try it. I've seen weirder things! I wouldn't rule out the firewall until I have disabled it. 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.
August 24, 2023 at 3:24 pm
I mean, in the end the design is up to you, but for me, I don't see the point of storing the monthly and yearly values when you have 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.
August 24, 2023 at 3:14 pm
As a quick check before disabling the firewall, what about if you log into the SSRS server and try uploading from the server itself? That SHOULD bypass the firewall.
Since 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.
August 24, 2023 at 2:36 pm
First step - check the logs. The Windows logs, the SQL logs, and most importantly the SSRS logs.
With what you said, there is nothing for us to go 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.
August 23, 2023 at 4:09 pm
Why bother storing something that you can calculate out when you query the data?
What I mean is your table should have only the required data and then build views to...
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 23, 2023 at 4:05 pm
The below is entirely my opinion - feel free to ignore what I say.
If you are not running frequently at 100% CPU, then you are not having CPU pressure.
Having your...
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 23, 2023 at 3:53 pm
First I want to say I've not used system versioned temporal tables before, but from reading about them, the below logic makes sense to me.
Step 1 though is to read...
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 3, 2023 at 8:20 pm
If they are "kosher" login attempts as you say, then this sounds like users fat-fingering credentials. If this is the case, I would push back on the app writers and...
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 3, 2023 at 5:15 pm
In SQL, I would avoid a loop at all costs. I would estimate that 90% (likely a lot higher) of the time you do not need a loop.
Now, my approach...
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 2, 2023 at 2:10 pm
Without being in your environment, this is just guesswork, but my GUESS is that the server "Abcdef" is on a different domain than dev.com or possibly that server lost 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.
August 1, 2023 at 9:42 pm
Varchar(max) can hold more, but if you really need to store a huge amount of json data, it may make more sense to store it on disk and parse it...
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.
April 20, 2023 at 4:21 am
Are you doing a reorg of all indexes followed by a rebuild of all indexes? I REALLY hope not as that is redundant.
But reasons it could be slow that come...
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.
April 19, 2023 at 7:49 pm
Probably a dumb suggestion, but do you get the error if you run the restore as sa? I KNOW you said permissions are good, but when the system gives me...
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.
April 19, 2023 at 6:01 pm
Just so I understand the issue:
LIVE system - 2 hours to do index maintenance
TEST system - 10 minutes using the backup of live that is restored nightly
TEST system - 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.
April 19, 2023 at 5:55 pm
Viewing 15 posts - 571 through 585 (of 2,917 total)