Viewing 15 posts - 526 through 540 (of 2,917 total)
I would take Jeff's advice here. Plus, the question about if logical or physical reads are more important to performance tuning can be found by doing a google for "performance...
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 20, 2023 at 2:12 pm
Apart from the advice above, I'd check all of the disks and any place that the backup file sat for any period of time to make sure that you aren't...
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 19, 2023 at 10:07 pm
I think the easiest way to do it would be to script out all of the stored procedures that do cross-database communication, drop them, generate the bacpacs, import the bacpacs,...
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 18, 2023 at 4:28 pm
That is a bit scary and odd... have you reported this to MS? If they are aware of it and it is a limitation of the function, they should document...
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 18, 2023 at 3:59 pm
Did it work better when run outside of Visual Studio?
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 14, 2023 at 8:09 pm
I think this depends on the P2V tools and VM host. But this is more of a server question than a SQL question. My advice would have been to not...
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 14, 2023 at 7:01 pm
First step is to review the error message. Without seeing the EXACT error message (and any associated errors) it is hard to say what the problem is. If I had...
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 14, 2023 at 6:55 pm
To add to what Jeff said, DBA in the cloud is a VERY similar skill set to DBA on premise. On the back end, it is all the same thing...
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 12, 2023 at 9:08 pm
Step 1 - check the docs:
things to note:
ODBC data sources are not supported for multidimensional solutions
AND if you want to connect to other databases, you need an "An OLE DB...
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 12, 2023 at 5:41 pm
I'm still thinking this is either:
A - expected behavior <-- that is there is an error message being sent in the email notification
B - bug in Visual Studio or SSDT...
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 12, 2023 at 5:29 pm
The ONLY reason I see to use powershell for a backup process would be if you needed to move the file to a location that the SQL agent service didn't...
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, 2023 at 8:14 pm
According to the MS docs, that shouldn't be happening. As a really random thought - is it possible that an error did occur, just not the way you were thinking?...
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, 2023 at 8:11 pm
As a random guess, does the SQL Agent Service account have access to the file you are trying to rename? If I had to guess I would say It 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.
September 11, 2023 at 3:12 pm
My opinion, I would ask them to do basic troubleshooting to validate that the disk is good. Just because other systems are running fine now, doesn't mean they will continue...
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, 2023 at 3:07 pm
If I had to guess, I'd say that the transaction is not committing.
But my first steps when troubleshooting things like this are to check things like profiler or extended events...
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, 2023 at 7:36 pm
Viewing 15 posts - 526 through 540 (of 2,917 total)