Viewing 15 posts - 1,411 through 1,425 (of 2,917 total)
It really depends. Yours looks to be customized as the "Subsequent failures" option is set to run a program (powershell) which I am fairly confident is non-standard.
My approach for systems...
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 11, 2021 at 4:52 pm
Step 1 - FULL BACKUP. Take a full backup so you can get back to your current state.
Step 2 - fix the snapshot issue. Quick google:
Which basically says you PROBABLY...
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 11, 2021 at 4:45 pm
Pretty sure it needs access to the internet to do what is needed for license validation.
That being said, why do you need this installed on a server? I don't think...
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 11, 2021 at 4:11 pm
As an alternate thing about the performance (just a guess as we have no DDL or query itself), indexes MAY not help. You say that it is a table with...
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 11, 2021 at 2:58 pm
I think what Jeffery was getting at was "who is the SQL Server Agent Service set to run as?". I have a feeling it is NT Authority/System which doesn't have...
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 11, 2021 at 2:45 pm
To answer your questions I would say "it depends". For you, I would say do it all application side and just push the row across to SQL with a simple...
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 8, 2021 at 10:11 pm
The logs are stored on disk along with the SQL instance in a folder called "Logs". You will be looking for the file "ERRORLOG" (no file extension) and you 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 8, 2021 at 10:00 pm
To me that sounds like it should be a good test set. I would also try forcing the failover by having the VM go offline (reboot the VM and see...
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 8, 2021 at 9:58 pm
Have you checked the SQL log? That will likely tell you what is wrong.
Now, if memory serves, the MSVCP100.dll is the Microsoft Visual C redistributable, so if that got updated...
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 8, 2021 at 9:49 pm
First question is easy. SELECT <columns> FROM <table> WHERE <date column> = CAST('09.01.2021' AS DATE)
Second question is a bit more tricky as it depends. This would likely be handled 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.
January 8, 2021 at 8:39 pm
Quick google brought me to Microsoft's website on that view and to quote them:
Returns counts of different types of index operations and the time each type of operation was last...
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 8, 2021 at 5:30 pm
Possible? yes. Would I do it? no.
The reason I wouldn't do it is you are going to have a whole bunch of tables that are named by the date. Each...
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 8, 2021 at 2:06 pm
I would reach out to the vendor of the BODS tool myself. I expect that the tool has a timeout (possibly the default) for keeping the connection open to SQL. ...
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 5, 2021 at 8:24 pm
I can't see any reason why it wouldn't work as long as @CurrentToken is defined. I've run stored procedures inside an SSRS report. I think it needs to return 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.
January 4, 2021 at 7:27 pm
I agree with Jeff here - find the problem queries and you will find the performance problems. fix the problem queries and you will likely fix the performance problems.
The exception...
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 4, 2021 at 5:12 pm
Viewing 15 posts - 1,411 through 1,425 (of 2,917 total)