Viewing 15 posts - 1,516 through 1,530 (of 2,917 total)
To me this sounds like the audit is running as a different account than the backup.
When you create the audit file on the local drive, who is the "owner" of...
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.
October 22, 2020 at 7:39 pm
Since it is going out to a network share, it could be that someone else is doing something on that share at the same time as your backup. I am...
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.
October 21, 2020 at 5:02 pm
My first step - check the logs.
Is the error coming from the load balancer or SSRS? Do you get the same error if you go directly to the machine rather...
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.
October 21, 2020 at 4:31 pm
Check your execution plans. That will be the best way to tell what is changing with performance.
As for returning NULL when there is data, chances are the stored procedure is...
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.
October 21, 2020 at 4:00 pm
How busy is the disk when you go to do the backup? Is it an SSD or HDD?
I have a database that is roughly 400 GB and it can back...
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.
October 20, 2020 at 9:24 pm
My guess (as I've not seen your system or that behavior before) is that it isn't actually fixing anything. What I expect is happening is you have a query 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.
October 20, 2020 at 9:02 pm
If memory serves, ASYNC_IO_COMPLETION wait type is related to writing to disk. Quick google tells me that is correct:
Occurs while waiting for non-data-file disk I/O to complete. For example while...
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.
October 20, 2020 at 8:54 pm
It depends on the query. If the query is an INSERT or an UPDATE query, adding an index may slow it down.
You can update statistics though without creating indexes. Those...
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.
October 20, 2020 at 2:53 pm
The issue is with your UPDATE.
So lets run through this code logically.
Make the objects - no problem here
Set variables - no problem here
loop - "while @rows > 0" ok, lest...
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.
October 9, 2020 at 9:16 pm
I think you forgot the execution plan. Without that it is incredibly hard to say with any certainty what would help.
indexes may help, or you may already have the ones...
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.
October 9, 2020 at 9:02 pm
I've found that SOMETIMES you need a CHAR(10) AND CHAR(13) before it puts in a new line. Other times, I've found that having both confuses the tool representing the data...
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.
October 9, 2020 at 8:45 pm
Yep. Alternately to making your presence known online, if you know people in your community who are looking for DBA's or even a DBA group (SQL Server user group 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.
October 9, 2020 at 8:41 pm
It depends. Are you looking to change jobs/careers or stick with your current position?
If you are sticking with your current position, see what the company expects of you. Talk 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.
October 8, 2020 at 8:17 pm
My opinion on this - it depends. If the demand for DBA's and Developers is low in the area you live in, finding contracts may be tricky. I imagine 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.
October 7, 2020 at 9:43 pm
I am not familiar with PLSQL, but with the method you are doing in that query, you are doing a 1-1 comparison, so @ID MUST be a single value, unlike...
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.
October 5, 2020 at 9:57 pm
Viewing 15 posts - 1,516 through 1,530 (of 2,917 total)