Viewing 15 posts - 376 through 390 (of 2,917 total)
With the new job, did you use the same start date? If so, may not hurt to bump the new start date up to the next expected run date.
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.
January 17, 2024 at 4:12 pm
Another question for you then - is it consistently FAST and SLOW if you run the same query in SSMS and the ERP OR is it only fast/slow in 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.
January 17, 2024 at 3:05 pm
So that is based on your start date. Jan 1st, 2015 + 26 months is March 1st, 2017. Next run is May 1st, 2019, then July 1st, 2021, then September...
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.
January 17, 2024 at 2:59 pm
Are you really using SSRS 2005 or 2008? If so, I would recommend upgrading to a supported platform.
But, I wouldn't recommend adjusting the files manually when there is a GUI...
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.
January 17, 2024 at 2:44 pm
To add to what Grant said, are you using this in a stored procedure and passing that B700 and C900 as parameters? If so, then this could be a parameter...
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.
January 17, 2024 at 2:31 pm
Have you tried deleting the schedule and making a new one?
I've had schedules not behave the way I want (usually after doing in-place upgrades) and deleting the schedule and recreating...
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.
January 17, 2024 at 2:24 pm
Are you able to switch to simple recovery mode and do a backup? If so, that should put your log file down to 99% unused at which point you should...
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.
January 16, 2024 at 8:18 pm
Maybe I am a bit ignorant here, but can't Excel save as CSV? Do you really need an SSIS package to convert an Excel file to CSV?
Failing that, powershell can...
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.
January 15, 2024 at 8:12 pm
My understanding is this is often done for performance purposes. If you are on spinning disk (HDD) and the MDF + NDF are on the same disk, then the benefits...
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.
January 15, 2024 at 8:04 pm
To me it looks like your Antivirus thinks the installer is infected. If you are 100% confident that the installer is NOT infected (ie you got it from Microsoft 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.
January 15, 2024 at 7:51 pm
My opinion - predicting log file usage is tricky and often not a good use of resources (your time and energy). I've seen systems that have 0 transactions one hour...
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.
January 14, 2024 at 8:31 pm
Just to play devil's advocate here - be careful adding indexes. Each new index causes some data duplication on disk. So the more indexes you have, the slower your DML...
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.
January 14, 2024 at 7:22 pm
Quick guess - this is a stored procedure? If so, then the change in plan is due to change in parameters. It kind of looks like a parameter sniffing problem....
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.
January 14, 2024 at 2:30 pm
Just wanted to add in that the "working 8-4" thing is something that only happened recently as my work contract got changed. At one point, I was on call 24/7/365...
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.
January 14, 2024 at 2:19 pm
A nice read for a Saturday morning. I remember back when I started in my current department and I thought "one day, I want to be a manager like 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.
January 13, 2024 at 6:18 pm
Viewing 15 posts - 376 through 390 (of 2,917 total)